Data Sql Server
Resume:
DIVI CHOWDARY
************@*******.***
SUMMARY
Over 9+ years of IT experience in Analysis, Design and Development of Applications.
Over 8 years experience with Informatica Power Center.
Designed Star schemas, Snowflake schemas for Data Marts and Data Warehouses
Proficiency in developing SQL’s with relational DB’s Oracle 11g and DB2 V9.
Expertise in using Informatica 9.1 PowerCenter Client tools - Mapping Designer, Workflow Manage, and Workflow Monitor.
Experienced in tuning Informatica Mappings, Sessions for better performance.
Experience in tuning the SQL queries at database for better performance of reports.
Experience in UNIX commands and in creating new/modifying unix shell scripts for file processing, data validations and job executions.
Expertise in scheduling Informatica jobs using Informatica scheduler and Control-m.
Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies
Extensively used Slowly Changing Dimension (SCD) techniques, implemented Error Handling Methodologies.
Highly proficient in identifying performance bottlenecks and fine-tuned the processes in Informatica and at database level.
Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.x/8.x/7.x/6.x ETL tool.
Expertise in using transformations effectively. Expert in developing reusable transformations, mappings, sessions and tasks. Handled external code like stored procedures and scripts through informatica.
Expertise in scheduling Informatica jobs using Informatica, $U and Control-M
Experienced in working as team lead
Experienced in working on projects following Agile Methodology.
Experienced in developing applications for Healthcare, Banking and Insurance domains (developed applications for Horizon BCBS/Wellpoint/Statefarm Insurance/Achmea)
Good analytical, strong interpersonal and excellent communication skills.
Technical Skills
Informtica 9x/8.x/7.x, Oracle 10g(TOAD), DB2 V9, Teradata V13, SQL Server, SQL, PL/SQL, Microsoft Visio, Windows NT/2000/XP, HP-UX, Business Objects 6.x, $Universe, Control-M, Mercury Quality Center, PVCS, Kintana, PPM, Perforce
PROJECTS SUMMARY
Cisco Systems Sept 2015 – Till date
Sr. Informatica Developer
Description: EDW CIBER Attach Rate reporting system provides the attach rate calculation on products purchased thru 1-tier partners & directly from Cisco and a complete picture of attach rates by theater, region & account managers which incorporates 2-tier purchases with the 1-tier & direct purchases.
Responsibilities
Translated business processes into Informatica for building data marts.
Worked with different sources such as Oracle, SQL Server and Flat files.
Created source table definitions in the Informatica repository by studying the data sources.
Designed Informatica ETL jobs for extracting data from heterogeneous source systems, transforming and finally loading into the data marts.
Created re-usable components using shared containers for local use or shared use.
Created audits to validate number of records and revenue.
Created shell scripts that will invoke the Informatica jobs passing all variables for job to execute with parameterized databases connection information.
Scheduled Informatica workflows using Control-m.
Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
Developed various operational Drill-through and Drill-down reports using SSRS
Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
Served as a SSRS 2000 Reports Developer and SQL Server Developer in support of Service Management System
Designed and developed a decision tree application using Neo4J graph database to model the nodes and relationships for each decision. Deployed in Amazon Web Services using Neo4J server implementation. Application includes machine learning capability to expand the number of options.
Presented talks on Neo4J Graph Database and how to build applications using it at the Denver Open Source User Group and the Graph Nerds of Boulder Groups.
Created standard and best practices for Talend ETL components and jobs.
Documented the functionality and restartability features of the code for ongoing support.
* In creating complex mappings, extensively used transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure.
Created reusable transformations and mappings by using mapping designer,
transformation developer in Informatica PowerCenter and used them in mappings.
Involved in building the ETLSource to Target mapping to load data into Data warehouse and created mapping documents to outline data flow from sources to targets.
Importing & exporting database using SQL Server Integrations Services (SSIS) and Data Transformation Services (DTS Packages).
Environment: InformaticaPowerCenter 9.5.1, Oracle 11g, Teradata TD13.10, Teradata Tools and Utilities, SQL Server, UNIX, MS Visio, SSRS
KPMG LLP Sacramento,CA Aug 2013 – Sept 2015
Sr. Informatica Developer
Description: KPMG Worked as the Implementation Partner to ptovide the heatlh care Management Information for State of HAWAII.Worked on the case management Reports i.e(Daily work,Activity,CMS,Trending,,Notice,Benefits, Long term Cases…etc)
Responsibilities:
Actively involved in understanding the environment and the business requirement.
Worked closely with the Users in order to understand the requirement and performed Gap Analysis.
Informatica Designer tools are used to design the source definition, target definition and transformations to build mappings.
Developed and implemented Error Handling Strategies
Created Informatica workflows, parameter files to make code reusable, develop audit system to check number records for a file, schedule the workflows, peer review, document test results and move code to perforce.
Involved in unit testing and code migration from one environment to another.
Worked with production support team and coordinated creation of new objects in test and production environments
Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
Completed a Hackathon project that classifies key words into categories using a Neo4J graph database and makes a recommendation.
Implemented Graph Database application for movies and actors listed in IMDB.com using Neo4J
Completed a Hackathon project that classifies key words into categories using a Neo4J graph database and makes a recommendation.
Designed ETL architecture and architecture documents.
Performed an active role in shaping and enhancing overall ETL Informatica architecture.
Involved in discussing strategies and roadmaps for Informatica PowerCenter Grid implementation with key business stakeholders.
In creating complex mappings, extensively used transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure.
Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries..
Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)
Generated several drill down and drill through reports using SSRS. Created deployment groups, migrated the code into different environments.
Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
Environment: Informatica Power Center 9.1.0, DB2, Flat files, Windows NT, Mantis Bug Tracker, UNIX, Shell Script, Java Script, Tortoise SVN, Winscp, Putty, IBM Data Studio 3.1
New York State Office of Mental Health, Albany, NY Nov 2012 – August 2013
Sr. Informatica Developer
Description: PCS site is one of the tools that the NYS Office of Mental Health uses to evaluate all of the programs licensed or funded by the NYS Office of Mental Health is the Patient Characteristic Survey (PCS), which is a one week survey conducted every two years. Results from the Patient Characteristics Survey are summarized into reports at the state, region, county and facility levels. The reports posted on this site allow users to sort data by geographic region of provider and other demographic variables. The PCS is the only OMH data source that describes all of the mental health programs in New York State. The information that is compiled is available on the OMH public website, and is used for planning and program evaluation by OMH and local governmental units; the results are also used to describe the state public mental health system to state and federal funding agencies and legislative bodies.
Responsibilities:
Troubleshooted the Informatica connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
Performed Unit, Integration and Regression testing to validate report and mapping functionality.
Working Closely with users/developers and administrators to resolve the production problems by reviewing design changes.
Setup the Topology including physical architecture, logical architecture and context.
Created new models for the data sources – flat files, MS SQL server, Oracle.
Did reverse engineering for the data sources and targets.
Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB.
Did SQL and PL/SQL programming for Informatica and oracle.
Created PL/SQL stored procedures, functions and triggers.
Developed interfaces for loading the lookup and transactional data.
Installed and configured TOAD for Oracle and MS SQL Server.
Created Informatica packages, scenarios using interfaces, variables, procedure
Used Informatica commands like ODIFile_Move, odiFileAppend, odiFilecopy etc
Implemented logic to archive the source files with date stamp affixed after the successful load.
Performance tuned the Informatica interfaces.
Optimized the knowledge modules to improve the functionality of the process.
Performed unit and integration testing. Created various test scenarios to test the application.
Delivered the assignments before the deadlines.
Conducted code reviews and planned the knowledge transfer to client.
Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, Power Exchange, DB2, SSIS, SQL, PL/SQL, XML, TOAD, MS Access, Windows XP, UNIX.
Praxair Corp, Danbury, CT July-2011 – Nov 2012
Sr. Informatica Developer
Description: Praxair, Inc. is a large international industrial gases company. Praxair supplies atmospheric, process, and specialty gases as well as high-performance coatings and related services. I was involved in the HR Department and Manufacture Department (Canada and US) Projects. We created the reports for the General Ledger of the products, Sales, Marketing and Production Statistics of the Company. I been also involved in the Creating AD hoc Reports based on the requirements of the End User
Responsibilities:
Involved in Analysis, Requirements gathering, functional /technical specifications, development, deployment and testing.
Performed Unit, Integration and Regression testing to validate report and mapping functionality.
Working Closely with users/developers and administrators to resolve the production problems by reviewing design changes.
Implemented basic security and external table authentication security mechanism
Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
Implemented Security by authenticating against the LDAP and external table.
Modify existing ETL jobs in Informatica (9).
Spearhead development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures.
Designed the detailed ETL architecture, including agents, scenarios, packages, data mappings, data extractions, transformations and validations. This ETL design and implementation will include standalone and Java EE agents, Informatica data services, Informatica Console, Informatica studio, and other appropriate development tools.
Implemented Informatica interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Planning, Essbase, Relational Database Management servers (including Oracle RDBMS, SQL Server, and IBM DB2), flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security).
Performed the unit testing, system integration testing and assist with user acceptance testing
Documented the ETL detailed design and test results.
Created and maintained integration process using Informatica and load rules
Liaisoned with Oracle support for Service Requests (SRs) and resolution of any issues
Documented new requirements, recommended and implement solutions
Coordinated testing and changes to the application
Ensured data quality throughout entire ETL process.
Developed technical understanding of the application, as well as, an understanding of how the business uses this information and the data flows from system to system in order to define and execute cross-functional data movements for business intelligence
Environment: Informatica Power Center 8.1, Oracle 9i, SQLServer2005, DB2, MS Access, Windows XP
Wells Fargo, San Leandro, CA Aug-2010 – July 2011
Sr. OBIEE/Informatica Developer
Description: Profit AX is a proprietary system of Wells Fargo & Company, which presents information on Customer profitability at various levels (Customer, Relationship, Officer, AU, Organizational Unit (OU), etc.) in total or by product. Information is displayed for single and multiple time periods as specified by the User. The ProfitMAX System has two basic modes of usage: Inquiry and the Report Module. In addition, the ProfitMAX System has a set of utilities accessible through a menu system such as File Upload, Customer Account Search, Relationship Structure, and Compensation Assignment.
Responsibilities:
Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements
Developed statements of work, interviewed potential candidates and assisted in knowledge transfer for consultants
Created need/want analysis matrix for stakeholders to help them set project priorities and scope
Managed teams of 4 – 6 consultants for a consulting company specializing in Internet application development
Analysis and design of current ETL implementation.
Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements
Developed statements of work, interviewed potential candidates and assisted in knowledge transfer for consultants
Created need/want analysis matrix for stakeholders to help them set project priorities and scope
Managed teams of 4 – 6 consultants for a consulting company specializing in Internet application development
Use the best practices of business intelligence to administer the analytical solutions
Perform validation of data on the reports and monitor the performance status of the same
Assist and administer the deployment process of UNIX, OBIEE and repository codes
Prepare monthly reports and present it to the management
Assess production faults and critical issues followed by identification of the root cause
Provide remedial measures to the production issues or process failure
Interacted with SME's to gather subject area specific requirements and developed Packages using the developed interfaces, procedures and variables.
Used pl/sql functions to perform control logic.
Debug the sessions by utilizing the logs of the sessions.
Responsible for Metadata Administration and managed models and reverse engineering.
Environment: Informatica Power Center 8.6.1 - (Designer, Repository Manager, Workflow Manager), Oracle 9i, Oracle 10g, TOAD, SQL Developer, AQT, UNIX Shell Scripts
Oracle Knowledge(Inquira)/Oracle Corp, Orlando, FL Aug-2008 – July-2010
Informatica Developer
Description: By enabling searches across a wide variety of sources, Oracle's InQuira knowledge management products offer simple and convenient ways for users to access knowledge that was once hidden in the myriad systems, applications, and databases used to store enterprise content. To help users of their Websites find answers amid a growing mountain of online information, companies are turning to enterprise search (ES) or enterprise knowledge management (EKM). ES is designed to index large amounts of information with the goal of making that content searchable. Few of the Clients are Lufthansa,Emirites,Hawaioan Airlines,C&M Airlines, Executive Airline
Responsibilities:
Conducted research and analysis of business requirements, problems and available technologies to define systems solutions that increase efficiency and effectiveness.
Involved in translating functional requirements into technical requirements.
Interacted with Procurement and Operation / Maintenance business representatives for gathering the OBIEE Reports / Dashboards requirements and to define business and functional specifications.
Analyzed and used various data sources – DB, XML, Excel, and OLAP.
Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modelling.
Used MS office plug-in for analyzing data.
Implemented write back functionality.
Analysis and design of ETL processes.
Worked in the implementation of DW Incremental (pull and load) that constitutes different subject areas like (Payroll, Financial Transaction, Compensation Request, Agreement, Party, Contact Point) for different source systems.
Interacted with business analysts and modelers for better understanding of individual subject areas and modified specifications to reflect accurate user needs.
Mapped the source and target databases by studying the specifications and analyzing the required transforms.
Worked with Data modeler on logical and physical model designs
Worked closely with team leads in process of standardizing job parameters, job flows, audit process and rollback strategies that hold major attention for the successful implementation of DW Incremental.
Used Topology Manager module to manage the data describing the information systems physical and logical architecture.
Used the Informatica Power Center to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
Configured and setup Informatica master repository, work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition, metadata.
Environment: Informatica 8.6, Control M, Unix, Oracle 10g, TOAD, OWB, Business Objects, $U Scheduling tool
Boston Medical Center, Boston, MA Aug 07 – July08Informatica Developer (Off shore SLK technologics, Bangalore India And Onsite )
Description: Boston Medical Center is one of the best hospitals in USA and is well known for its superior services in multiple fields. The project, Easy Chart was an EHR application which allows the user to handle tasks like storing and editing the paper documents in digital format, maintain patient charts (Medicine history, FMHX, PMHX, Routine Medications, and Insurance etc.), integrate Lab results with patient’s diagnosis reports and provide real time updating of central server database. The software also handles various healthcare plans, efficiently adopts the changes made in those plans and handles healthcare claims. It was a client-server application which encrypts the communication to avoid VPN. It has Care Tree which records encounters (patient progress history), tests and other records.
Responsibilities:
Involved in gathering end user requirements, User/System documentation, user training and testing developed reports for final deployment.
Business analysis user requirements Financial and Benefit Enrollment reports.
Responsible to collate appropriate data for use in databases and conduct related research.
Generated reports using IT / database systems and assist in their analysis.
Involved in the designing and Building of Universes, Classes and objects for investment management system.
Excellent use of graphs and charts with named groups and formula fields.
Extensively used ETL and Informatica to load data from Oracle, MS SQL Server, flat files into the target Oracle 11g database.
Used Informatica features to implement Type I & II changes in slowly changing dimension(SCD) tables. Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
Analyzed the existing Crystal reports and tuned for faster execution. Troubleshoot existing reports to eliminate data discrepancies and respond to end-user inquiries.
Wrote SQL and PL/SQL and stored them in Crystal Query and attached them to the Crystal Reports using the Proper ODBC connections.
Environment: Oracle10g, Teradata, TOAD, Informatica 8.6
Contact this candidate