PROFESSIONAL SUMMARY

• 7 plus years of experience in gathering Requirements, Analyzing, Designing, Testing, Implementation, Deployment and Support of Data Warehousing and Business Intelligence Applications (full SDLC).
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling and Snow - Flake Modeling for FACT and Dimensions Tables.
• Highly experienced in whole cycle of 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.
• Experience with Programming in SQL Server - Stored Procedures, Triggers, User-defined Functions and Views, Cursors, Performance tuning of Stored Procedures and T-SQL Queries.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Database Backup, Recovery and Disaster Recovery procedures for large, medium and small database instance.
• Through at understanding existing data models, data flows and data dictionaries and creating new data models, data flows and data dictionaries using Normalization and De-Normalization techniques.
• Strong experience in creating Framework Manager Models with 3 Layer approach (Database Layer, Intermediate Layer, Presentation Layer) and publishing packages for BI authors for reporting needs.
• Hands on Experience in Report Studio for creating advanced and professional reports.
• Experience in building Complex Reports including Templates, List Reports, Cross-tab Reports, Maps, Repeater tables, Charts, Complex Financial Reports, Drill through, Master-Detail Reports, burst Reports and Conditional block lists.
• Worked on Security access to clients using Access Manager and worked with Data Access, Object Access and Package Access in Frame Work Manager.
• Strong experience in deploying SSIS/Cognos packages, models and reports from Development to Production and administering users/groups/roles.
• Extensive experience on production support and troubleshooting issues with existing reports.
• Installation and Configuration of Cognos TM1 Test and Prod environments for financial planning and budgeting projects.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes and corrections.
• Interested in emerging technologies and have an ability to quickly master new concepts.

TECHNICAL SKILLS

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012/2014,Teradata, Oracle 11g/10g and Access.

ETL tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Import/Export Wizard,Wherescape and Bulk Insert.

Reporting Tools: SQL Server Reporting Services (SSRS), Cognos BI, TM1, Crystal Reports and Excel

Languages: T-SQL, PL/SQL, VB.NET, C#.NET, ASP.NET, C, C++.

Operating Systems: Windows 95/98/NT/2000/2003/XP, Unix, Linux and MS-DOS.

WORK EXPERIENCE

BI Developer

Confidential, Houston, TX

Responsibilities:

• Worked with business users to gather business requirements and mapped into technical requirements for developing the BI reports.
• Developed various T-SQL stored procedures, views and adding/changing tables for data extraction, data load and transformations.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Involved in up gradation of models and reports from Cognos 10.2.2 to Cognos 11.0.9.
• Opened many cases with IBM Cognos Support Team to resolve the issues occurred during the upgrade process.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Created Executive Dashboard to bring multiple reports together to show information in context.
• Extensively worked on resolving report issues relating to data anomalies working with Database team.
• Built complex reports, Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Cognos Report Studio.
• Implemented Security at data, object and package level in Framework Manager.
• Developed several Dashboards with drill-downs to various detail reports.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.
• Participated in deployments, production release of SSIS, Cognos packages and Reports .
• Provided documentation and tutored the end users on using cognos Analytics.

Environment: Cognos 11/Cognos10, MS SQL Server 2012/2014, BIDS SSIS, SSRS, SSMS, Visual Studio 2012.

SQL/Cognos Developer

Confidential, Columbus, OH

Responsibilities:

• Identified business needs and documented the business requirements.
• Developed database objects like tables, functions, views and stored procedures.
• Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL Server Agent.
• Worked on SSIS Script component using Visual Basic Applications and C#.
• Developed and Published Packages in Cognos Framework Manager - Connecting and testing the data source, creating database layer and presentation layer, defining appropriate relationships between query subjects.
• Designed and developed reports against multiple data sources .
• Created daily, weekly, monthly and quarterly reports for the management team.
• Scheduled, refreshed and bursted Reports according to user requirements in Cognos connection and distributed them through email.
• Monitored data quality, resolving problem data issues, and ensuring timely updates
• Worked with Cognos SDK team in designing the parameter page and with various cross application teams for rendering report in XML, PDF, and HTML format.
• Worked with different client teams to support Reporting issues and enhancing the existing reports.
• Backed up, restored system & other databases as per requirements, and also scheduled those backups
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Managed Package Configurations in XML Files and SQL Server Tables to efficiently Promote Unit tested packages to different environments (System Integration Testing, User Acceptance Testing and Production Environment) from Development Environment.
• Used kingswaysoft in SSIS packages to create/upsert data in the Microsoft Dynamics CRM tool.
• Used Autosys to schedule command, file watcher and NDM file transfer jobs using batch scripts.

Environment: Cognos 10.1.1(Framework Manager,Cognos Connection, Cognos configuration, Cognos planning, Query Studio and Report Studio), MS SQL Server 2008(R2), BIDS SSIS, SSRS, SSMS, Visual Studio 2010.

Cognos Developer/Admin

Confidential, San Francisco, CA

Responsibilities:

• Worked with Cognos 10, creating DMR models and publishing packages to the Cognos Connection using Framework manager.
• Troubleshoot Cognos Server Environment for the better performance.
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Deployment of reports from Development to Production.
• Moved Packages and reports from development to QA and then Production servers.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Analyzed and validated the report and performing data analysis by writing complex SQLs
• Coordination for Integration testing, UAT, UTC and smoke tests and resolving the support issues.
• Working with different client teams to support Reporting issues and enhancing the existing reports.
• Developed Technical Specification documents for all newly developed and modified processes.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.

Environment: Cognos 10.1,Cognos 8.4/8.3(Framework Manager, Transformer, Cognos Connection, Cognos configuration, Cognos planning, Query Studio, Report Studio, Metric Studio, Event Studio, Cognos workspace, Cognos Workspace Advanced), Oracle11g.

Cognos Developer

Confidential, Los Angeles, CA

Responsibilities:

• Extensively worked with Business Team and Functional Team to review business requirements, and Functional clarifications.
• Created customized, Complex reports in Cognos Report Studio and Ad-hoc reports in Query Studio.
• Developed many Complex Reports as List, cross tab, drill through, master-detail, chart using Report Studio.
• Designed reports with Cascading Prompts, Filters, and Custom Calculations.
• Monitored data quality, resolving problem data issues, and ensuring timely updates
• Involved in deployments of Packages and Reports to different environments.
• Developed Master detail reports, Multi query and Multi page master reports as per BRD (Business Requirement Document).
• Worked on DMR to create models in the Framework Manager
• Created multidimensional cubes using Impromptu’s Query Definition in PowerPlay Transformer
• Created complex package reports using conditional blocking / conditional formatting / conditional layouts as per business requirements.
• Implemented Security filters at Package level, Object level, Data level to meet user needs.
• Analyzed and validated the report and performing data analysis by writing complex SQLs
• Coordination for Integration testing, UAT, UTC and smoke tests and resolving the support issues.
• Working with different client teams to support Reporting issues and enhancing the existing reports.
• Developed Technical Specification documents for all newly developed and modified processes.
• Handled day to day adhoc requests and issues given by key users and resolved in time.
• Participated in deployments, production release.
• Responsible for development and automation of Client using IBM Cognos tool.

Environment: Cognos 8.4(Framework Manager, Transformer, Cognos Connection, Cognos configuration, Cognos planning, Query Studio, Report Studio, Metric Studio and Event Studio), Teradata, Windows 2003 server and Unix.