TECHNICAL SKILLS

• ETL/BI Tools: SSIS, SSAS, SSRS, Informatica, Talend, Crystal Report, QlickView, TIBCO
• Databases: MS SQL Server 2008,Oracle 11g SQL, PL/SQL , MS Access
• Languages: SQL, PL and SQL,C, C
• Operating Systems: Windows 7,Linux, Mac mountain Lion
• Microsoft Technology: ASP.NET, C .NET, ADO.NET,AJAX
• Web Technology: HTML, CSS, Java Script, XML
• Office Automation Tools: Microsoft Office, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Source data analysis, design and documentation

• Parsed high-level design spec to simple ETL coding and mapping standards
• Used Informatica designer for developing various mappings
• Designed and developed ETL Mappings using Informatica to extract data from flat files and Oracle, and to load the data into the target database
• Successfully created complex Informatica mappings to load data in to the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator
• Extensively used various transformations like Source Qualifier, Joiner, Aggregation, Connected and unconnected lookup, Rank and Filter
• Extracted data from various sources like SQL server, Oracle, and relational databases
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables
• Administrating User Privileges, Groups and Folders which includes creation, update and deletion
• Migration of New and Changed Informatica objects across the environments using Folder to Folder and Deployment Group methods
• Analyzed newly converted data to establish a baseline measurement for data quality
• Translated the business processes into Informatica mappings for building the data mart
• Performed unit testing on the given tasks after performing the appropriate mappings
• Worked on SQL tools like TOAD to run SQL Queries to validate the data
• Created PL/SQL procedures to populate base data mart aggregation structure
• Used PMCMD/PMREP commands for running Informatica from backend
• Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from and to different servers
• Worked on ILM data archiving tool
• Worked on ILM data engine and FAS file archive server
• Troubleshooting the errors in ILM jobs with Informatica support
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services SSIS on different Data Sources
• Facilitate scrum ceremonies sprint planning, retrospectives, daily stand-ups, etc.
• Working in a Scrum Agile process with two week iterations delivering new features and working software at each iteration

Environment:

• Informatica Power Center 9.1/9.5
• Interacted with business analyst and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the Data marts
• Assisted in Product design meetings with the client PCA
• UNIX Shell Scripting
• SSIS
• Talend
• SQL server 2008, ILM-Data Archiving 6.1
• Developed a standard ETL framework to enable the reusability of similar logic across the board
• Involved in System Documentation of Dataflow and methodology
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into Data Mart using the Power Center
• Developed common routine mappings. Made use of mapping variable mapping parameters
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart
• Developed Slowly Changing Dimension for type I and type II flag, date
• Used mapplets for use in mappings thereby saving valuable design time and effort
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows
• Written procedures, Queries to retrieve data from DWH and implemented in DM
• Worked on creating Views Materialized views from the database perspective
• Used shell scripts in UNIX to execute the workflow
• Responsible for submitting DBA requests, following up with data base DBA's and Informatica administrators, creating remedy ticket, handling all the signoff's for the production, updating all changes with new versions using START team, creating test cases using Quality Center
• Written SQL Queries, Triggers and Stored Procedures to apply and maintain the Business Rules
• Developed Sub Reports, Matrix Reports, and Drill down reports, using SQL Server Reporting Services SSRS and worked on querying data and creating on-demand reports using Report Builder
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance
• Written Indexes, primary keys and checked other performance tuning at data base level
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning
• Involved in generating reports from Data Mart using Cognos
• Performed testing for assigned projects and performed necessary test evaluation and reporting including defect tracking
• Designed plan for a MS-SQL Server 2008 and effectively wrote queries
• Data analysis for Refractor PreBeta tools and reported bugs using PCA Central tool
• Analyzed and generated results reports for various component using SQL queries
• Experience in testing application in Waterfall and Agile development process

Environment:

• Informatica Power Center 9.1/9.5
• SQL server 2008, ILM-Data Archiving 6.1
• Business Objects 6.5
• Cognos
• UNIX Shell Scripting

ETL Developer,

• Collaborated with business client to analyze current system performance and formulated the best approach to improve the efficiency of the application without impacting the dependent interfaces
• Analyzed business needs and created detailed technical document based upon business requirement
• Involved in designing and building data marts for provider division
• Loaded data to the interface tables in oracle from multiple data sources such as MS Access, Sybase, SQL Server, text files and excel spreadsheets using Informatica
• Designed data transformation from staging to fact and dimension tables in the warehouse
• Implemented aggregate, filter, join, expression, lookup and update strategy transformations
• Implemented variables and parameters in transformations to calculate billing data
• Developed Mapplets using corresponding source, targets and transformations
• Created sessions, sequential and concurrent batches for the mappings using server manager
• Test all the applications and transport the data to target warehouse oracle tables, schedule and run extraction and load process and monitor sessions by using Informatica server manager
• Developing, executing monitoring Autosys Process Scheduler jobs
• Involved in designing logical and physical database designing using ERWIN tool
• Involved in admin tasks like analyzing table space requirement, load balancing and performance
• Involved in tuning memory, I/O bottlenecks, resource contention, sorts and free lists
• Writing stored procedures, triggers, functions and packages to implement business logic
• Created mappings between source and target using Informatica power center designer
• Used mapping and mapplet designer to generate different mappings for different loads
• Created transformations like source qualifier, joiner transformation, filter, update strategy, lookup transformation, rank transformations, expressions, aggregator and sequence generator to load the data from staging area to ODS and to DW in oracle
• Created, scheduled and monitored sessions and batch process based on demand, run on time, run only once using Informatica server manager

Environment:

• Informatica Power Center 6.1
• Windows NT. Windows 2000 Server
• MS-SQL Server 2000, Oracle 9i
• Cognos
• UNIX Shell Scripting
• SQL Server Integration Services SSIS
• Server Analysis Services SSAS
• Reporting Services SSRS 2005
• Business Intelligence Development Studio BIDS
• Crystal Reports
• Microsoft Access FTP Communication

ETL Developer,

• Studied and analyzed software requirements specification SRS for client
• Implemented Crystal reports as per requirements of clients
• Involved in installation and configuration of SQL server 2000 on Servers
• Applied patches and service packs to keep the database at current patch level
• Implemented database standards and naming convention for the database objects
• Implement and maintain database security
• Implemented trigger and stored procedures and enforced business rules via checks and constraints
• Fine-tuned Stored Procedures, using Execution Plan in T-SQL for better performance
• Going through the clients' requirements and coming up with database design and application architecture
• Troubleshoot and minimize production down issues
• Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method
• Data conversions and data loads from various databases and file structures
• Monitor failed and long running MS SQL Server jobs
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance
• Maintaining User account administration for Different domains
• Tested and deployed the developed application to production, also provided support

Environment:

• Analysis performed to discover issues with source data
• Implemented data warehouse using MS SSIS, Talend, Informatica Cloud, AdventureWorks2008 R2, MS SQL Server 2008 R2 and delivered reports for the business requirements
• Windows 2000 Server
• Crystal reports7
• T-SQL
• DTS
• SQL Server 2000
• Created SSIS packages to perform data transformations. Profiling and cleansing of redundant, null, duplicate data
• Implemented an ETL mapping specification, created ETL jobs to perform data capture, data transformations and integration using slowly changing dimension SCD technique to load data into MySQL warehouse destination

Advances in Data Integration and Architecture, Advance Database Management, Data Warehousing and Business Intelligence, Application Engineering, Information Technology Auditing and Assurance, Business Analysis, Information Systems for Healthcare Services Delivery, IOS Development iPhone application