Swetha Tammali

· Worked closely with various stakeholders to gather requirements and convert them into consumable data points

· Implemented solutions to process Customers (HCP and HCO) for mastering, Customer hierarchy, EDI 867, SPP redistribution, Patient Services, Synoma, Symphony (pharmacy, medical and surgical claims), CRM activity, IQVIA DDD, Exponent, LAAD data.

· Identify the impact of the requirements to the client specific project

· Extensively involved in documenting functional requirements, design documents, STTM, project plan and estimation documents. ·

· Ensured the applications met the business specifications and the code adhered to the project standard.

· Developed and implemented test plans to ensure that the systems and programs are tested and debugged.

· Contribute to the data enrichment activity as a technical subject matter expert.

· Monitoring and managing DQM framework built for various datasets in EDB.

· Implemented best practices, standards and procedures including quality and delivery methodologies.

· Responsible for creating new project proposals including solution design diagram, work plan, effort estimates.

· Had built & managed team at both onshore and offshore.

· Have experience in preparing SOW, Cost Estimation, resource planning for onshore / offshore execution mode.

· Responsible for preparing response for RFPs.

· Collaborated with key stakeholders to collect and translate business requirements into actionable data points.

· Assessed the impact of business requirements on client-specific projects and aligned them with project goals.

· Created detailed documentation for functional requirements, design specifications, project timelines, and estimations.

· Designed, developed and tested several ETL routines in Informatica to load data into Commercial Data Warehouse (CDW) that will streamline reporting needs.

· Created and implemented SSAS cubes to improve data analysis and reporting functionality.

Designed and developed new reports using SSRS (SQL Server Reporting Services), ProClarity, Business Objects, Tableau and Power BI.

· Designed and executed comprehensive test plans to validate and debug systems and programs, ensuring high-quality delivery.

· Worked extensively on various datasets like VCEN, SPP Redistribution, CRM, Symphony, IQVIA...etc.

· Implemented solutions to process Customers (HCP and HCO), Customer alignment, EDI 867, SPP redistribution, Patient Services, Synoma, DDD, Symphony (pharmacy, medical and surgical claims) and CRM activity data.

· Implemented best practices, standards and procedures including quality and delivery methodologies.

· Worked on proof of concept to migrate ProClarity reports to Power BI.

· Developed and Managed iTrend field reporting application built using Microstrategy.

· Created, and owned several project documents starting from Discovery and ending at post-Production deliverables by closely working with business teams.

· Worked closely with various stakeholders to gather requirements and convert them into consumable data points.

· Designed , developed and tested several ETL routines in Informatica, SSIS packages and SSAS cubes that will streamline reporting needs.

· Analyzed Data Stage jobs and created Mapping in Informatica accordingly using required transformations.

· Extensively used Informatica Client Tools – Source Analyzer, Transformation Developer and Mapping Designer.

· Used designer debugger to test the data flow and fix the mappings

· Performed Data Extractions, Data Transformations, Data Loading, Data Conversions and Data Analysis.

· Working on different transformations like Source Qualifier, Lookup, Joiner, Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy

· Extensively Worked on MicroStrategy end to end development and design of dashboards.

· Involved in creating Sessions & Workflows in Workflow Man

· Developed workflows and tasks using Informatica Power Center Workflow Manager.

· Created Unit Test Case Document, Detailed Design Document and Knowledge Transfer Document.

· Used Parameter files to avoid hard coding and reusability of code

· Created and managed reports using Business Objects and MicroStrategy.

· Used AWS tool for job scheduling

· Developed SSIS packages to bring data from Flat Files, Excel files, Oracle and deployed to production server using package configurations.

· Used For each loop for iterative loading and Send mail task for E-mail notification

· Created SSIS Packages with error handling and implemented breakpoints to check status of package.

· Used transformations like conditional split, row count, derived column, union all, character map, merge and containers like for each loop, sequence container.

· Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

· Generated on-demand reports and scheduled reports for business analysis or management decisions.

· Worked on tasks like Execute SQL, ftp, Send mail, for each loop container, Derived column, conditional split

· Regular monitor of servers, which includes backups and troubleshoot all the issues on regular basis.

· Scheduled reports for daily, weekly through Report subscriptions based on business needs.

· Formatted Reports using Global Variables, Expressions and Functions and implemented stylish report

· Working in an agile Environment to deliver higher-quality software far more rapidly.

· Participated in the database design and analysis with the business users and technical

· Involved in design and development of several ETL routines using Informatica

· Designed and developed BO (Business Object) Reports.

· Effectively communicating with client facilitating the query resolution process

· Prepared weekly status reports and monthly influx reports

· Implementing Quality Policies and Practices in work products.

· Understanding the Data Model of the project.

· Understanding the Application and Business.

· Analyzing the requirements.

· Coding, development and Backend programming for Data Load Application.

· Used ADO.NET to SQL database programming to access and retrieve data from the SQL Server 2005/2008 database.

· Implemented version controlling using Visual Source Safe.

· Created Crystal reports on the web page by accessing the database.

· Unit testing and Bug Fixing for Data Load and Reporting Application.

· Coordination with onsite team.