SUMMARY

• Over 13+ year of experience in IT includes extensive Functional and Technical experience in Data Warehouse, Business Intelligence (BI) and Web Applications.
• Extensive experience in all phases of software development life cycle (SDLC), Agile, Lean methodology of Data Warehouse, Business Intelligence and Web applications, including requirement gathering from business users, analysis, architecture, design, creation of project documents, technical specification writing, development, testing and implementation.
• Experienced in designing and implementing Conceptual, Logical and Physical Data Models in RDBMS.
• Proficient in OLTP/OLAP systems and Relational/Dimensional Modeling, Fact & Dimensional Tables, Star and Snow Flake Schema and Parent/Child Relational Tables.
• Extensively worked in Oracle and MS SQL Server databases (SQL, PL/SQL, performance tuning, Creating, Designing and Maintaining DDL scripts, database objects like Tables, Table partitioning, Indexes, Stored Procedures, Functions, Views, Sequences, SQL Jobs, Packages, Update Statistics, Database Backup & Restore and etc.) for developing different applications.
• Extensive experience in Data Acquisition, Data Integration, Data Conversion, Migration and developing ETL (Informatica) mappings, transformations, implement business rules using Designer, Repository Manager, Workflow Manager, Workflow Monitor and Adminstration.
• Experience in installation/configuration of Informatica server, upgrade, applying patches and fixes. Data Masking/De - identification of production data in different environment (UAT/Test/Dev). Migration of Informatica Server from Unix to Windows and converted Unix shell scripting into VBScript to automate the ETL jobs.
• Setup Informatica environments and Configured Repository & Integration Services. Used Informatica command line utilities such as pmcmd to execute Powercenter workflows/tasks in parallel, all repo related admin tasks such as backup, restore etc., implement the best practices and performance tuning, Created new users and new groups and granted proper access to stakeholders.
• Extensive experience in Heterogeneous Source/Target Systems (Oracle, MS SQL Server, DB2, Flat, CSV and Excel Files) for Data Warehouse.
• Worked with business analysts, other team members and clients to review the business requirements and translate them into database objects.
• Heavy interaction with end-users/team leads for new application specifications, ad-hoc queries and daily request to support organizational decisions and policies.
• Re-engineered numerous complex stored procedures for maximum performance and implementation of Microsoft best practices.
• Data mapping, cleansing & migration/conversion of legacy data from various sources (FileMaker & Excel/CSV/Text files) into SQL Server.
• Code review of all database objects developed by team members to certify the code, output and performance prior to releasing into QA and Production environments.
• Developed database build scripts, product release notes & installation guides.
• Responsible for production and/or mission-critical issues and needs on 24x7 basis.
• Monitor and respond to all database jobs and activity.
• Established SQL Server development standards & best practices and Mentor internal staff.
• Experience in designing of Relational and Dimensional Model in Cognos FM using different databases for creating Models, Packages, calculations, and publishing packages.
• Experience in Cognos Administration, Security, roles and groups for authentication, Content Administration and Deployment.
• Extensively used Cognos packages using Report Studio, Query Studio, Analysis Studio for ad-hoc, canned, drill-through, master-detail reporting.
• Experience in creating data visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Bullets, Heat maps and etc.
• Designed and Developed MS SQL Server Reporting Services (SSRS) reports, Crystal reports, MS Excel Power Pivot and Pivot reports using databases and cubes.
• Experience working in the functional domains of Health Care, Education, Finance and Manufacturing.
• Experience in Configuration, Release and Deployment management. Code reviews and walkthrough. Identifying, documenting and implementing process improvement initiatives.
• Mentored and trained users in the successful execution of the project.
• Self-motivated and possess excellent critical thinking ability, good interpersonal and communication skills, team-oriented.
• Ability to work under stringent deadlines with teams as well as independent.
• Handling and mentoring offshore team, keeping them up-to-date with latest technologies, tasks assignment and status reporting.
• Learning open source tools & technologies for Data Science, Data Visualization, Data Processing, BIG Data and Machine Learning using R, Python, HDFS, Map Reduce, YARN, PIG, Hive, Sqoop, Spark, HBase, NoSQL databases (MongoDB and Cassandra).

TECHNICAL SKILLS

BI Tools: IBM Cognos 10/11, SSRS, Crystal Reports, Power BI, DAX, MDX, SSAS, MS Excel Power Pivot & Pivot

ETL Tools: Informatica(Primary), SSIS(Secondary)

Operating Systems: Windows, Unix

Databases: Oracle, MS SQL Server, IBM DB2 Blu 10.5, Access DB

Languages: SQL, T-SQL, PL/SQL, HTML, XML, XHTML, VBScript, JavaScript, Shell scripting, .Net, Viusal Basic

Tools: ER/Studio 11, SQL Loader, Toad, SQL Developer, SQL EnLight, SQL Sentry 7x, MS Project, Microsoft Visio, MS Visual Studio, Sharepoint, VSS, TFS, Perforce, SCM, Jira, F-Secure SSH Client and Core FTP LE

PROFESSIONAL EXPERIENCE

Confidential, Jefferson City, MO

Architect / Sr. Developer

Responsibilities:

• Gathering customer requirements and involve in various business discussions with the end users of the application.
• Analysis of requirements, preparing design, technical, SMTD and project/process related documents.
• Providing technical and functional guidance/solution to team as necessary.
• Identifying, documenting and implementing process improvement initiatives for Adhoc Data Warehouse.
• Designing, developing and maintaining databases. Creating DDL scripts, Writing Stored Procedures, Packages, Functions, SQL queries, Views and Indexes. Updating table stats.
• Worked with business analysts, other team members and clients to review the business requirements and translate them into database objects.
• Heavy interaction with end-users/team leads for new application specifications, ad-hoc queries and daily request to support organizational decisions and policies.
• Re-engineered numerous complex stored procedures for maximum performance and implementation of Microsoft best practices.
• Code review of all database objects developed by team members to certify the code, output and performance prior to releasing into QA and Production environments.
• Developed database build scripts, product release notes & installation guides.
• Responsible for production and/or mission-critical issues and needs on 24x7 basis.
• Monitor and respond to all database jobs and activity.
• Designing, developing and maintaining Informatica ETL process and load the data in Oracle & DB2 Blu (Columnar and in-memory database) for application and reporting needs.
• Installation, Configration and Migration of Informatica from Unix to Windows. Unix shell scripting into VBScript to automate the process.
• Data masking/De-identification of production data in different environment (UAT/Test/Dev) for CVS and SumaCare Medicare clients.
• Release and Deployment Management for Databases, ETL and Reporting.
• Database, ETL and Reporting performance optimization.
• Handling customer escalation.
• Cognos Patch installation, Administration and User roles and group Management.
• Efforts estimates for the development and enhancements.
• Designing, developing and maintaining Cognos Framework Model and packages.
• Designing, developing and maintaining Dashboards, Report studio and Query studio canned and adhoc reports.
• Maintaining and publishing Data Model and Data Dictionary for Adhoc Data Warehouse.
• Designing, developing and maintaining MS SQL Server Reporting Services reports.
• Supporting production enviorments and applying data fixes in production.
• Co-ordinate with IBM and Informatica for any product related issues.

Environment: Unix, Windows, IBM Cognos 10 & 11 BI, Cognos Report Studio, Cognos Query Studio, Cognos Framework Manager, Oracle 11g, DB2 Blu 10.5, MS SQL Server 2012/2014, MS Access 2007, SSRS, Informatica PowerCenter 9x, Share Point Server 2013, Jira,VBScript, F-Secure SSH Client, Core FTP LE, ER/Studio 11, SQL Developer and Toad.

Confidential, Bellevue, WA

Senior Consultant

Responsibilities:

• Review gap analysis for new business requirements. Business Process Analysis and Impact analysis.
• Project Planning, status & milestones tracking and tracking day-to-day activities.
• High level design, Detailed Design, Project/Release planning, Problem analysis, Integration Testing, Acceptance testing, Documentation, End-user training, Co-ordination, Support, Mentoring, Customer interfacing.
• Publication of reports for Microsoft Online Services Division Finance using MS SQL Server 2012 SSAS cubes and MS Excel 2013 services.
• Working with Finance Engineering teams to deliver optimized reporting solutions.
• Support operational and service requests.
• Designing, developing and maintaining databases. Creating DDL scripts, Writing Stored Procedures, Functions, SQL queries, Views, Indexes and SQL Jobs. Updating table stats.
• Developing and Designing MS SQL Server Reporting Services reports.
• Developing and Designing MS Excel Power Pivot and Pivot reports on databases and cubes.
• Designing, developing and maintaining SSIS ETL process and load the data in MS SQL Server for application and reporting needs.
• Maintaining and publishing ERD using MS Visio.
• Release and Deployment Management for Databases, ETL and Reporting.
• Code Configuration Management using VSS and TFS.
• Database, ETL and Reporting performance optimization.
• Handling and mentoring offshore team, keeping them up-to-date with latest technologies, tasks assignment and status reporting.

Environment: .Net 3.5, C#, MS SQL Server 2008 R2/2012, MS SQL Server Reporting Services 2008 R2/2012 MS SQL Server Integration Services 2008R2/2012, MS Visio, Share Point Server 2007, TFS, Cubes (SSAS), MS Power Pivot and Pivot reports, VSS, TFS.

Confidential, NJ

Senior Techical Lead

Responsibilities:

• Key participant in due diligence, requirement gathering/analysis and capturing of business requirements.
• Client Coordination for technical issues and review.
• Designing, developing and maintaining databases.
• Creating DDL scripts, Writing Stored Procedures, Functions, SQL queries, Views, Indexes, SQL Jobs, Backup & Restore and User Role & group management. Updating table stats.
• Developing and Designing Business Objects Crystal Reports.
• Designing, developing and maintaining Informatica ETL process and load the data in MS SQL Server for application and reporting needs.
• Maintaining and publishing ERD using MS Visio.
• Release and Deployment Management for Databases, ETL and Reporting.
• Unit Testing and Code Review
• Code Configuration Management using VSS and TFS.
• Database, ETL and Reporting performance optimization.
• Handling and mentoring offshore team, keeping them up-to-date with latest technologies, tasks assignment and status reporting.

Environment: .Net 3.5, MS SQL Server 2005/2008, Informatica Powercenter 8.6, Business Objects Crystal Reports XI R2, Oracle 10g, VSS, TFS, SQL EnLight, SQL Sentry 7x, MS Visio, MS Project, Jira.

Confidential

Techical Lead

Responsibilities:

• Key participant in due diligence, requirement gathering/analysis and capturing of business requirements.
• Designing, developing and maintaining databases.
• Creating DDL scripts, Writing Stored Procedures, Functions, SQL queries, Views, Indexes, SQL Jobs, Backup & Restore and User Role & group management. Updating table stats.
• Developing and Designing MS SQL Server Reporting Services 2008 reports.
• Developing and Designing MS SQL Server Integration Services (SSIS) 2008 Packages for Data Migration (FileMaker Application Data) and EPM feed.
• Maintaining and publishing ERD using MS Visio.
• Release and Deployment Management for Databases, ETL and Reporting.
• Unit Testing and Code Review. Testing the Application for Database and Functional level.
• Code Configuration Management using VSS.
• Database, ETL and Reporting performance optimization.

Environment: .Net 3.5, MS SQL Server 2008, MS SQL Server Integration Services 2008, MS SQL Server Reporting Services 2008, VSS, Jmeter, Bad Boy.

Confidential, NJ

Techical Lead

Responsibilities:

• Creation of Report Specification Documents.
• Creation of the design approach for migration from actuate to crystal reports.
• Creation of Stored Procedures, Functions and Packages in Oracle.
• Creation of Reports using Crystal Report 2008.
• Unit testing of the reports and creation of Unit Test Case for each report.

Environment: Oracle 9i (PL/SQL), Business Object Crystal Report 2008, Actuate 8.0

Confidential

Techical Lead

Responsibilities:

• Client Coordination, Requirement Analysis, Design and development
• Analyzed the requirements and framed the business logic for the ETL process.
• Created PL/SQL procedures and Informatica mappings to improve warehouse loading.
• Implemented different business logic and rules to populate the relevant data into Various Distribution tables using stored procedures and views and then transformed these tables to the Data Mart.
• Performed Functional testing, Unit testing for the mappings and oracle code.
• Completed documentation in relation to detailed work plans, mapping documents and data models.

Environment: Informatica Powercenter 8.x, Windows Server 2000, SQL Server 2000, Crystal Enterprise 10.0ASP, JavaScript, VBScript, IIS 5.0

Confidential

Techical Lead

Responsibilities:

• Key participant in due diligence, requirement gathering/analysis and capturing of business requirements.
• Designing, developing and maintaining databases. Creating DDL scripts, Writing Stored Procedures
• Functions, SQL queries, Views, Indexes, SQL Jobs, Backup & Restore and User Role & group management. Updating table stats.
• Developing and Designing MS SQL Server Reporting Services 2005 reports.
• Maintaining and publishing ERD using MS Visio.
• Release and Deployment Management for Databases and Reporting.
• Unit Testing and Code Review. Testing the Application for Database and Functional level.
• Code Configuration Management using VSS.
• Database and Reporting performance optimization.

Environment: C#, .net Framework 2.0, XML, MS SQL Server 2005, MS SQL Reporting Services 2005, VSS.