SUMMARY:

• 12+ Yrs. Solutions - driven programmer with track record of commended performance in modular and object-oriented programming, Data Warehousing, Data Modeling and Business Intelligence.
• 11+ Yrs. Database, Data Warehousing & ETL (EDW, PDW, ODS)
• 11+ Yrs. MSBI stack - SSIS, SSRS, SSAS.
• 11+ Yrs. SQL Server Database, T-SQL & PL SQL.
• 4+ Azure cloud, MPP, PDW data warehouse experience
• 8+ years Of Business Intelligence Reporting and Dashboard.
• 10 + Yrs. .Net, C# and ASP.Net.
• 8+ Yrs. Agile Development.
• 4+ Yrs. Java, J2EE & Python.
• 4+ Yrs. Actuate BIRT, Crystal Reports.
• 4+ Yrs. Oracle, PL SQL.
• 5+ Yrs. Of Data Visualization using Tableau, Power BI. etc.

SOFTWARES & TOOLS:

Programming: C, C++, C#.NET, ASP.NET, JAVA, PYTHON

Operating Systems: UNIX, LINUX, WINDOWS. WINDOWS SERVER 2000/2003/2008/2012

Database: SQL SERVER 2005/2008// 2012/2014/2016 , MYSQL, MS-ACCESS, ORACLE 8I/9I/10G/11G/12C, DB2, Teradata, Postgres, Azure, NO-SQL, SQL, PL-SQL, T-SQL.

Business Intelligence: SSAS, SSIS, SSRS, ACTUATE /7/8/9/11/BIRT/ACTUATE ONE, CRYSTAL, INFORMATICA, POWER BI, TABLEAU, COGNOS, HADOOP, HIVE, SQOOP, PIG.

Other: LUIGI, POWER SHELL, TIVOLI, ERWIN, VISIO, TFS, SAS, TERADATA

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

Technical Lead

Responsibilities:

• Involved in analyzing, designing, modeling, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server SSIS, SSRS and SSAS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Wrote T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors, recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Participated Migration of Databases from SQL Server 2014 to 2016 and Azure Cloud DB.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into SQL data warehouse.
• Designed SSIS Packages to transfer data from flat file, XML to SQL Server Datawarehouse and Azure DB.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task FTP Task and Send Mail task etc.
• C# coding for Script Task, custom component creation.
• Created business reports, parameterized queries, drill through reports and formatted SQL server Reports in SSRS.
• Configuration of Reporting services and assigning permissions to different levels of users in SSRS.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Provided Production Support, Quick fixes and troubleshooting.

Environment: SQL SERVER 2012/2014/2016 , POWER BI, AZURE, C#.NET 4.5/4.6, ASP.NET, VS 2015/2017.

Confidential, College Station, TX

Technical Lead / Data Modeler

Responsibilities:

• Analysis, Data Modeling and Implementation of Marketing Campaign Data warehouse and integration to Marketo through SSIS.
• Extract Data into SQL server and Hadoop environment to Azure warehouse using Azure data factory and to on-premise SQL data warehouses.
• Extraction of data from multiple sources like Flat files, CSV, XML,SAS,TEARADATA,SAP and SQL databases and Sales force using REST API.
• Python scripting for data pipeline using Luigi.
• ETL for loading data from azure storage to Azure DW using Data factory and SSIS.
• Metadata driven ETL development using BIML and C#.
• Data Analysis and profiling using SQL Profiler, Meta data storage creation.
• Defining data warehouse multi-dimensional cubes & tabular models (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services and MDX queries for analytics.
• Used MDS for meta data management for BI.
• Created and deployed SSRS reports to Share point.
• Data Visualization using Tableau 10.1 and Power BI.

Environment: SQL SERVER 2012/2014/2016 , AZURE, C#.NET 4.5, T-SQL, PL-SQL, VS 2015.

Confidential, Buffalo Grove, IL

MSBI - Technical Lead / Asst. Project Manager

Responsibilities:

• Involved in analyzing, designing, modeling, developing, installing, configuring and deploying MS SQL Server Reporting Database.
• Extraction of reporting data from multiple databases like Oracle using SSIS.
• Convert existing oracle reports and PL/SQL codes that users are currently running themselves to be generated from Crystal Report Version 2013
• Administration of Business Objects server.
• Creating users, groups and roles.
• Creation of scheduled and interactive reports.
• Define procedures for users to run reports in Crystal Report Version 2013.
• Training Users to generate reports in Crystal Report Version 2013.

Environment: SQL SERVER 2012/2014, ORACLE 12 C, T-SQL, PL-SQL, C#.NET 4.5, VS 2013.

Confidential, Bellevue, WA

Sr. ETL/MSBI Developer

Responsibilities:

• Involved in all the phases of SDLC including Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application. Responsible for implementing the overall design specs, construction, coding and unit testing, production support.
• Designing and coding business intelligence cubes for Dashboard in SQL Server Analysis Service.
• Developed complex queries in T-SQL and MDX for SQL Server 2008 R2 databases and Oracle 11g databases.
• Development of new databases for the Product lines in SQL server 2008 R2, wrote complex SQL queries and stored procedures for fixing data.
• Developed ETL packages using SSIS 2008 R2 from diverse database and FTP files and XML.
• Python scripts coding to use with SSIS.
• Created Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart
• SSAS cube development from Datawarehouse for the dashboard.
• Participated in development of customizable Business Intelligence Dashboard framework.
• Development and customization of Dashboard codes using C#, ASP.net, HTML5, Java Script, jQuery.
• Business Report Development using SSRS and Data Visualization using Power BI.
• Integration of SSRS reports to Web Interfaces and SharePoint.
• Migrated the product to different servers and configured the product to run on different servers.

Environment: SQL SERVER 2008 R2/2012, ORACLE 11g, POWER BI, T-SQL, PL-SQL, C#.NET 4.5, VS 2013.

Confidential

Sr. Programmer / Analyst

Responsibilities:

• Involved in all the phases of SDLC including Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application. Responsible for implementing the overall design specs, construction, coding and unit testing.
• Created Custom Web parts, Custom Controls using Visual Studio 2005/2008.
• Development in MVC framework and used WCF and REST web services.
• Created ASP.NET User Controls to reduce the complexity of user interface design.
• Used Microsoft AJAX Toolkit Controls.
• Used HTML/HTML5, CSS3, C# and T-SQL and SQL server as backend.
• Web Pages are designed using ASP. Net, HTML and Common CSS techniques.
• Developed SQL Tables, views, indexes, stored procedures, functions, triggers, T-SQL and PL/SQL for SQL SERVER 2008 R2.
• Creates SSIS packages to load data from multiple sources to the SQL server 2008 database.
• ASP.NET web application and .NET components hosted in Server using Internet Information Server and .NET Framework 3.5.
• Deployment of business components like trader, transaction and portfolio using XML Web Services
• Extensively used XML, XSD and XSLT for styling the ASP.NET pages.
• Created multi-dimensional cubes from SQL warehouse using SSAS.
• Created complex business reports in SSRS.

Environment: SQL SERVER 2008 R2, POWER BI, T-SQL, PL-SQL, C#.NET 4.5, VS 2010/2012, BIDS.

Confidential, Chicago, IL

Actuate Lead Developer

Responsibilities:

• Involved in all the phases of SDLC including Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application.
• Conversion of Crystal Reports 6/7 and Actuate Reports to Crystal Reports XI R2 .
• Developed PL/SQL stored procedures, functions, triggers, Crystal and Actuate Reports for data manipulation and querying data for SQL server 2005.
• Developed Role based Security to authorize member to a specific Role.
• Interacting with the Barclays Business Analysts and Technical team for gathering the required information.
• Developed a detailed functional requirement design and specification for Business Reports and Inquiries.
• Reports include Cash Statements like Account Summary, Balance Summary, Transaction summary, Balance detail, Transaction Detail, Account detail where an Account Holder can specify ad-hoc parameters through a graphical user interface.
• Inquiries includes Account Coverage View, Account Group Consolidated View, Balance view (Account/Account Group), Transaction view (Account/ Account group) where customers can provide criteria as parameters through a graphical web interface and view the details returned by the web service in DataGrid.
• Created Actuate BIRT Report Development using Eclipse IDE.
• Development of Java / J2EE, EJB and JSP pages for reporting framework.
• Used Struts framework for development of Custom development of Active portal and UI development.
• Working with GIW Database Designers and Developers for mapping data from Barclays back end systems to GIW Data Mart.
• Used SSIS 2008 packages for data migration to GIW DataMart.
• Used component libraries and templates in various reports.
• Analyzed existing Confidential Direct reporting framework and updated Meta Data framework for white Label Clients.
• Controls in the reports will be fixed to the report layout during server execution. All the controls are stored as Meta data in RDBMS.
• Extensively used Parallel, Sequential, Group, and Report sections in the reports to display the data from one or more data sources.
• Provide production support and troubleshooting of Actuate reports.
• Created ad hoc parameterized reports to filter data by providing parameter values which user can specify at run time to get required output.
• Wrote complex SQL and SQL using Actuate Query Editor to retrieve data from Data Source.
• Developed and accessed Stored Procedures in a report to enhance the performance and reduce the report generation time.
• Used Report Bursting technique to generate multiple reports.
• Created conditional and cross tab reports.
• Customized the page layout of reports.
• Used Single Input Filters, Memory Buffers to filter and share data from data source.
• Used Hyperlinks to link different reports.
• Created Dynamic controls that can be selected by the user at run time.
• Designed reports for multiple platforms.
• Light customization of Active Portal to change logo and parameter pages.
• Overridden various methods at different levels of a report.
• Wrote test plans and executed the test scripts.
• Use Actuate Foundation Classes (AFC) for the various controls and database connections.
• Worked with other teams to analyze functional requirements for Interface Control, Global Information Warehousing, User Interface, and Client Activation.

Environment: SQL SERVER 2008 R2, ORACLE 8i, ACTUATE, T-SQL, PL-SQL, JAVA / J2EE, C#.NET 4.5, VS 2010/2012.

Confidential, Green Bay, WI

Actuate Developer

Responsibilities:

• Involved in all the phases of SDLC including Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application.
• Extensively used Actuate Foundation Classes, component libraries, templates Parallel, Sequential, Group, and Report sections, Report Bursting, Single/Multiple Input Filters, Memory Buffers, Hyperlinks and page level security in the Actuate reports to display the data from one or more data sources.
• Created ASP.NET User Controls to reduce the complexity of user interface design.
• Developed Code Generation (code smith) templates for generating code for Basic Business Layer as well as Data Access Layer for Software Development efficiencies.
• Web Interfaces are designed using ASP. Net, HTML and Common CSS techniques.
• Used SSIS ETL for data Extraction and Data mapping.
• Created Report Design Template called “Ameriprise Client Star Report”.
• Create T-SQL script, stored procedures for ETL and Reporting.
• Creates Spreadsheet reports using e. Spreadsheet designer.
• Performed Volume Administration of Encyclopedia Volume using Actuate Management Console.
• Wrote server configuration file for runtime execution parameters.
• Created ad hoc parameterized reports to filter data by providing parameter values which user can specify at run time to get required output.
• Customization of Active Portal to change logo and parameter pages.

Environment: SQL SERVER 2005/2008, ORACLE 8i, ACTUATE 9 SP1, T-SQL, PL-SQL, JAVA / J2EE, C#.