SUMMARY

• Over 10 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008/2008 R2/2012, and Oracle.
• Understand and translate business needs into data models supporting long-term solutions.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimize and update logical and physical data models to support new and existing projects.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments.
• Highly experienced in DTS/SQL server integration services (SSIS 2005/2008/2012 ) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Generating reports using SQL Server Reporting Services and MS Excel spreadsheets and Power Pivot.
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012 ). Generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.
• Creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience in data extraction, transformation and loading data using Informatica PowerCenter 9.0.1 (Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Participated in all phases of the Software development lifecycle (SDLC) using both Agile and Waterfall methodologies.
• 2 years of experience in software development, maintenance, testing and troubleshooting on Master Data Management (MDM), Metadata management, data quality, data integration and Oracle database environment in varisous Verticals such as Pharmaceutical, Health Care & Telecom
• Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Programming in SQL Server- Stored Procedures, Triggers, User-defined Functions and Views, Cursors.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Implementing SQL Server Indexing and Query optimization using Indexes.
• Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Highly experienced in DTS/SQL server integration services (SSIS 2005/2008/2012 ) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Generating reports using SQL Server Reporting Services and MS Excel spreadsheets and Power Pivot.
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012 ). Generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.
• Creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.

TECHNICAL SKILLS

• SQL Server Management Studio
• Enterprise Manager
• SQL Server Profiler
• T - SQL & PL/SQL
• Dynamic SQL
• Stored Procedures
• Triggers
• SSIS
• SSAS
• SSRS
• Informatica MDM 9.5.1
• Informatica Powercentre 9.5/9.1//8.6.0
• Informatica power Exchange 7.x/8.x
• Informatica Power Analyzer
• Informatica Data Quality(IDQ)
• Star & Snowflake Schema
• FACT & Dimension Tables
• Power Pivot
• EXCEL
• Data De-Normalization
• XML
• HTML
• DHTML
• HTTP
• Business Intelligence Development Studio (BIDS)
• Visual Studio
• SharePoint
• SQL Server 00
• Oracle 10g 9i
• TFS
• VSTS
• JIRA
• ERWIN Toad
• SQL* Loader
• Autosys
• Power Designer
• Unix
• Windows

PROFESSIONAL EXPERIENCE

Confidential, New York

Data Warehouse Architect

Responsibilities:

• Designed, Developed tested and implemented extraction, transformation and loading (ETL) processes using SSIS packages and advance T-SQL.
• Designed, Developed maintained and troubleshot SSIS packages used in production. Created packages in SSIS that assisted in refreshing daily and weekly reports.
• Researched, analyzed and resolved issues to related database systems SSRS, SSIS.
• Communicated with upper management and staff regarding system issues and product delivery issues.
• Managed multiple deliverables and communicated changes to deadlines were met.
• Designed and modified SSRS RDL for deployment or adjustments to existing reports
• Resolved issues with SSRS delivery such as subscriptions and data driven subscriptions.
• Used SQL Server Job agent to execute stored procedures, SSRS Data Driven Subscriptions, SSIS packages and Database Maintenance plans.
• Monitored the performance of all databases, for database size, performance, and hardware capacity.
• Developed extensive objects using T-SQL such as stored procedures, views, and functions for the use of the business.
• Collaborated with application developers and end users on project design and development plan.
• Monitored and fixed system issues that involved SSRS, SSIS and objects in SSMS.
• Developed and monitored scheduled jobs and maintenance plans.
• Granted and validated security roles, and accessibility of all database systems within the organization.
• Performed Database backups, Database restores, and created DB maintenance jobs.
• Worked with the Business to Define requirements and applied them in the design and development of projects.
• Tested code and performed UAT with end users before final production implementation.
• Knowledgeable in banking financial analysis techniques and methodologies.
• Worked with financial bank data and supported operation team with banking contest data.

Environment: SQL Server 2008 R2 /2012, SSIS, SSRS (2008, 2012), Windows 7

Confidential

Technical Lead / BI Designer

Responsibilities:

• Responsible for writing requirements for automation of online contract management tool.
• Involved in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists, customized IDD applications.
• Involved in the UAT testing of the Items Data Mart price files tool automation project.
• Responsible for handling Supply Chain Management Data Warehouse and related data base and online solutions.
• Work on writing use cases and requirements for Supply Chain Management data upload automation process.
• Involved in maintenance of reporting tools and processes utilizing Data Warehouse data.
• Worked with user support group to in corporate pharmacy contracts in the SCM Contract Catalog.
• Responsible for generating pricing reports from Finance & Procurement Data Warehouse and Data Mart using Business Objects.
• Responsible for managing the online contract management repository and items data mart pricing information.
• Work on formulating the ETL rules using Informatica and Ab Initio.
• Used Informatica Power Center 9.0.1for migrating data from various OLTP databases to the data mart.
• Worked with different sources like Oracle, flat files, XML files, DB2, MS SQL Server
• Extracted data from Sales department to flat files and load the data to the target database
• Developed complex mappings using Informatica to load Dimension & Fact tables as per STAR schema techniques.
• Extracted data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Data mart.
• Created various Informatica mappings and mapplets to load the data mart. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation (SCD Type-2).
• Used Debugger to identify the errors in the mappings and fix them
• Performed unit testing to validate mappings and populate the database
• Used TOAD and SQL Plus to write queries and interact with Oracle database
• Implemented several different tasks (Session, Assignment, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control) in the workflow
• Involved in writing UNIX scripts and used them to automate the scheduling process
• Error Handling handled in Informatica Mappings & sessions and also through validation script.
• Co-ordinated with DBA Team, Functional Team and offshore teams.
• Automation of job processing, establish automatic email notification to the concerned persons.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Used SQL Trace, Analyze, Explain Plan Utilities, and Hints for the performance tuning
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Worked with business users and gather data cleansing, data reconciliation and data convergence requirements
• Involved in Designing and developing the OBIEE/Siebel Metadata Repository (.rpd) using OBIEE/Siebel Analytics Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down, Hierarchies) & Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions and done code migration from one environment to other.
• Done Data cleansing, single and cross table structure profiling, analysis on data, and analyze the patterns with Informatica Data Explorer and generating reports and logs.
• Working on Informatica Developer(Informatica Data Quality)9.0.1 and Informatica Analyst9.0.1 to cleanse and profile the data
• Designed and implemented new job and replication set up, to enhance the execution time for full ETL process.
• Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.
• Review for Test Scripts, Test scenarios, technical design, Code and coding standards.
• Participate in Analyzing root causes of issue and its resolutions.
• Offshore team management.
• Risk management.
• Planning and handling of project schedules and deliverables with MPP.
• Manage the onsite-offshore communication on a daily basis

Environment: Informatica Developer9.0.1, Informatica Analyst9.0.1, SQL Server, SAS. Informatica 9.6.0 & 9.5.1, SSRS, SSIS, Informatica Data Quality 9.6.0 & 9.5.1, Oracle 11g, UNIX, MS SQL Server, MDM, Teradata, MS Access, PL/SQL, My SQL and flat files, HP ALM, Microsoft Dynamics AX.

Confidential

MSBI Lead Designer

Responsibilities:

• Providing solutions at the Data Warehouse Architect level
• Involved in Data warehouse/Data mart implementations including project scoping, requirements gathering, dimensional modeling, Star & Snowflake Schema design
• Installation of Power Center and configured Development, Testing, Stage and Production Database repositories
• Implementation of Informatica Grid Architecture on Veritas Clustered Shared Servers (VCS).
• Configured Integration services on Grid and setup High Availability
• Tested HA script to successfully failover the PowerCenter services on to the backup node.
• Implemented folder structure at the domain level and in the repository.
• Provided training to the team for PowerCenter 9.X version.
• Installing Oracle and creating database instance.
• Automating export, import, oracle monitoring, and space monitoring using sell scripts.
• Assisted development team in performance tuning existing PowerCenter sessions.
• Provided consulting services for designing and developing ETL Components using Informatica’s Velocity Methodology principles and best practices.
• Reviewed existing configuration parameters of the PowerCenter Server and provided recommendations for improving the ETL processes.
• Understanding the existing Business rules and data flow to populate the Decision- Making Information into new era EDW.
• Supervised the Offshore development activities.
• Created migration strategies and change control processes for Informatica Repositories and database objects across multiple environments.
• Developed and implemented performance tuning strategies for mappings and sessions across all developed Informatica Components.
• Developed templates used for the documentation of overall ETL architecture and development strategies.
• Participated in the design and implementation efforts for the creation of near real-time data feeds to some of the Applications in TFS.
• Created Standard migration checklist & promotional checklist document template
• Created Unit Testing document template
• Trained developer’s on Team based deployment and Metadata Manager
• Created dashboard using Data Analyzer.Auditing Tables In Various Subject Areas
• Documented all the project work in support for maintenance
• Documenting the types and structure of the business data
• Escalating promptly any issues that may impact operations.
• Producing stage plans, highlight reports, risk logs, requests for change etc
• Providing strategic direction during the implementation stages.
• Managing client expectations by ensuring the delivery of the highest quality service
• Acting on client feedback.
• Monitoring staff & team performance.

Environment: Informatica Power Center 9.X, DB2, Oracle 10g, Flatfiles, WinSQL, Solaris, AutoSys, DataAnalyzer, Reflection, TOAD

Confidential

BI Lead

Responsibilities:

• Providing solutions at the Data Warehouse Architect level
• Involved in Data warehouse/Data mart implementations including project scoping, requirements gathering, dimensional modeling, Star & Snowflake Schema design
• Installation of Power Center and configured Development, Testing, Stage and Production Database repositories
• Implementation of Informatica Grid Architecture on Veritas Clustered Shared Servers (VCS).
• Configured Integration services on Grid and setup High Availability
• Tested HA script to successfully failover the PowerCenter services on to the backup node.
• Implemented folder structure at the domain level and in the repository.
• Provided training to the team for PowerCenter 9.X version.
• Installing Oracle and creating database instance.
• Automating export, import, oracle monitoring, and space monitoring using sell scripts.
• Assisted development team in performance tuning existing PowerCenter sessions.
• Provided consulting services for designing and developing ETL Components using Informatica’s Velocity Methodology principles and best practices.
• Reviewed existing configuration parameters of the PowerCenter Server and provided recommendations for improving the ETL processes.
• Understanding the existing Business rules and data flow to populate the Decision- Making Information into new era EDW.
• Supervised the Offshore development activities.
• Created migration strategies and change control processes for Informatica Repositories and database objects across multiple environments.
• Developed and implemented performance tuning strategies for mappings and sessions across all developed Informatica Components.
• Developed templates used for the documentation of overall ETL architecture and development strategies.
• Participated in the design and implementation efforts for the creation of near real-time data feeds to some of the Applications in TFS.
• Created Standard migration checklist & promotional checklist document template
• Created Unit Testing document template
• Trained developer’s on Team based deployment and Metadata Manager
• Created dashboard using Data Analyzer.

Environment: Informatica Power Center 9.X, DB2, Oracle 10g, Flatfiles, WinSQL, Solaris, AutoSys, DataAnalyzer, Reflection, TOAD

Confidential

Sr. Developer /Sr. Analyst

Responsibilities:

• Created new mappings and updating old mappings according to changes in Business logic.
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i RDBMS in accordance with requirements and specifications.
• Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Stored Procedures and Joiner etc.
• Performed Unit Testing and tuned the mappings for better performance.
• Created reusable transformations and mapplets.
• Writing PL/SQL procedures days of supply for processing business logic in the Database.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Worked on database connections, SQL Joins in Database level.
• Extensively used SQL to load Data from flat files to Database tables In Oracle.
• Used Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Using Unix Shell Scripting for scheduling Informatica workflows.
• Used calculations, variables, sorting, drill down, slice and dice for creating Stock Status Report.

Environment: Informatica Power Center 8x, Oracle 10g, Windows NT, Flat files, TOAD, SQL, PL/SQL.

Confidential

SQL Developer/Analyst

Responsibilities:

• Written SQL Queries for handling data in the database.
• Maintaining the data coming from the OLTP systems.
• Tuned the database queries to improve the performance of the query and indexing strategies.
• Coded database triggers to record the changes made to the database objects.
• Coded functions and stored procedures to perform the user defined functions and execute the required query whenever needed.
• Document the work performed each day.
• Helped coding shell scripts for database scripting.
• Establishing an application's security measures during developmentof Application in collaboration with DBAs.
• Involved in Physical schema implementation, objects like table-space, table rollback segments.
• Created database structures, objects and their modification as and when needed.
• Managed users & roles for database security.
• Maintained system security, control and monitor user access to database
• Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces.

Environment: Oracle 9i, SQL Plus, PL/SQL, T-SQL, Windows XP

Confidential

SQL Developer/Analyst

Responsibilities:

• Extensively worked on understanding the business requirements and actively involved in designing the security Implementation for required SQL server applications.
• Working with Stored Procedures, Views, and Aggregated Tables for Bug fixing and Problem solving.
• Working on Drill through strategy of SSAS, SSRS and ProClarity for analysis.
• Creating UTC for the report generation
• Support and Enhancement works For SQL Server Projects Using SSIS, SSAS, SSRS and ProClarity.
• New Report generation using SSRS and ProClarity.
• Bug fixing, Problem solving and Enhancement works as per Clients requirement.

Environment: Oracle 9i, SQL Plus, PL/SQL, T-SQL, Windows XP

Confidential

SQL Developer/Analyst

Responsibilities:

• Developed routine and ad hoc reports using SQL Server 2005 and MS Excel.Developed and maintained daily, weekly, and monthly reports using SQL Server 2005.
• Used data mining tools and methodologies to assist with testing and design of new database.
• Developed reports by evaluating data quality and performing data cleansing as needed.
• Performed UAT and quality assurance and testing for external Vendor Data to data mart.
• Used Excel pivot tables to summarize data sets and for data analysis.
• Reviewed and modified functional requirements for business process and business exceptions.
• Proficient with Excel formulas used to calculate and create business models.
• Documented the business processes through different project life cycles.
• Developed and tested queries using SQL Server 2005 and Advanced Excel.
• Assisted technical teams with data cleansing activities to ensure data integrity and quality.
• Assisted in training associates in using SSRS tools and data analysis.
• Communicated project goals, objectives, project status, and deliverables with client and staff members.
• Developed, and deployed T-SQL scripts for reports in SQL Server 2005.
• Worked alongside ETL team in development, test and production environments.

Environment: Oracle 9i, SQL Plus, PL/SQL, T-SQL, Windows XP