SUMMARY

• Over 8 years of IT experience in software development, designing and implementation with major focus around Business Intelligence, Data Warehousing and Database Applications.
• Hands on experience on T - SQL, MSBI-SSIS, SSAS, SSRS, MDX, DAX, Power Pivot and Power View reports.
• Experienced with full life Cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.
• Experience in Designing Business Intelligence Solutions with Microsoft SQL Server 2008 and … using MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Excellent skills in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase, Excel Sheets, Flat Files and MS Access.
• Experience in developing custom reports and creating various types of reports like On demand, drill down, Drill-through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Cross-Tab, graphical, distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).
• Having development experience of .net components for reusable content framework for SSRS reports.
• Experienced Interacting with the business users to gather report requirements and finalize the deliverables.
• Expertise in developing reports related to Market Research & Analysis, Design & Modeling of Supply Chain, Economic Analysis of Industrial Projects and Resource Planning.
• Extensively worked on Documents and Dashboards to facilitate customized multi-report display for advanced visual effects and give the privilege to business users for better business analysis.
• Developed Scorecards for key performance indicator, including all drill options. Use of drill maps to jump and segregate data in required form.
• Experience in developing Security Filters, Access Control Lists, Security Roles and assigning privileges.
• Good knowledge in building intelligent cube reports to analyze data from different source systems.
• Experienced in Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, Security, queries execution and scalability issues suited for Oracle, Teradata, DB2 and SQL Server.
• Good understanding of Data Warehousing concepts, Data Modeling and OLAP.
• Experienced in developing database applications using DB2/SQL Server, ODBC. Extensive knowledge in RDBMS and PL/SQL, experienced in creating Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Worked comprehensively in the Oracle, Teradata, Netezza, IBM DB2 and SQL Server Database environments

TECHNICAL SKILLS

BI Tools: SSAS, SSIS, SSRS, BIDS, Informatica Power Center, OBIEE, Crystal Reports, Data Modeling

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power, ProClarity, Microsoft Office.

Databases: Oracle 10g/11g/12g, DB2, SQL Server, Teradata, Netezza

Data Modeling Tools: IBM Infosphere Data Architect, ERWIN, MySQL, MS VISIO

Languages: C,SQL/PLSQ, HTML, JavaScript

Operating Systems: UNIX, Linux, Microsoft Windows 00/NT/XP/7, MS-DOS.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

MSBI Developer

Responsibilities:

• Gathered requirements from IT top level management.
• Created Target Databases, Tables, Cluster/Non-Cluster Index.
• Development of .net components for reusable for reports in SSRS.
• Efficient use of Joins and sub-queries in queries that involve data from multiple tables.
• Validated data by writing SQL queries in source and target database.
• Developed SSIS package to pull required data from source and mapped them to target database.
• Created packages using different transformations like sort, derived column, union all and aggregate.
• Used different types of tasks like execute Sql flow task, data flow task, send mail task to extract and load data to target databases.
• Used sequence container to execute data flow tasks in parallel.
• Configured SQL Mail agent for sending automated alerts/email.
• Deployed SSIS package to SQL Server and scheduled it to run daily using SQL Server Agent.
• Generated custom and parameterized reports using SSRS.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Created subscriptions to provide daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created SSAS Tabular semantic model with partitions, hierarchies and calculated measures using DAX as per business requirements.
• Built Dashboards /Reports/ combine different datasets and publishing using Power BI Desktop tools.
• Worked on Visualization, Merge queries and enhancements using Power BI desktop tools.
• Worked on deploying, sharing reports/Dashboards to Microsoft Power BI service.

Environment: Windows server 2012, SQL Server 2012, Microsoft BI Suite 2012, Microsoft Visio, Power BI, C#, SSMS, BIDS, MSBI (SSRS, SSIS, SSAS), Erwin, Team Foundation Server, FTP, MS-Visual Studio.

Confidential, Jersey City, NJ

MSBI Consultant

Responsibilities:

• Designed and created SSIS packages to extract, transform and load data from Excel and Text to SQL Server destination using various complicated transformations like conditional split, derived column, and data conversion for fee schedules from the existing QNTX database.
• Modified the existing packages by making changes in the stored procedures according to the requirement.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Transferred data from various OLTP data sources such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008R2.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report services (SSRS).
• Used various data flow transformations like conditional split, look up, derived column etc.
• Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Involved in performance tuning for new databases and existing databases by using SQL profiler.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS.
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Involved in troubleshooting, enhancing and creating new ones of claims retro report templates.

Environment: SQL Server 2008 R2, MSBI (SSIS, SSAS, SSRS), MS SQL Server 2012/2008/2005 , Oracle 12c, VISIO, PL/SQL, Visual Studio 2012/2008, Windows server 2012

Confidential, PA

MSBI Developer

Responsibilities:

• Build a data cube around the existing offer click, impression and revenue statistics from redirectors.
• Construct different hierarchical dimensions suitable for offer analyst to use.
• Build a set of reports which includes historical same-period comparisons.
• Enhance and build selected redirect reports with the flexibility of an OLAP service
• Created SSIS packages to load data into staging table and data mart and Performed logging in SSIS packages to capture error data and for error handling.
• Used the SSIS to migrate Databases such as Access database, flat files to centralized IT destination.
• Performing T-SQL tuning and optimizing queries for reports that take longer execution time.
• Extract data from flat files which comprised of header and input files to SQL server 2012 and Created Testing scripts for staging validation, generated the Map Force file for mapping between flat file and database.
• Developed Logical and Physical models based on the business requirements. Created ER Diagrams using Visio.
• Created MOLAP Cubes and automated the Processing options on different servers. Optimizes the processing time by tuning the DSV queries and created SSIS Packages eliminating complex syntax in Data Source View.
• Created the Partitions, Aggregations and various custom Member calculations in the Cube. And also, developed drill through actions which would navigate to SSRS reports deployed to Report manager.
• Defined Attribute relationship, created hierarchies and for ease of use grouped the attributes to folder structure within the dimension structure as Attributes, Hierarchies.
• Created different kind of reports like cascading reports, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports and charts in SSRS 2008R2.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Working on Creating partitions and Designing various storage modes to increase the performance of a cube using SSAS.

Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), SSAS, SSRS, OLTP, Visual Studio 2010, SQL Server Management Studio, Excel, TFS, Windows XP.

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Wrote complex SQLqueries using joins, stored procedures and used defined functions to verify the data from the database to generate reports based on the business requirement.
• Dynamically supported business users for given requirements and developed the reports accordingly.
• Developed various T- SQLstored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Created (SSIS) packages to get data from various sources.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Extensive T- SQLProgramming involving Development of Stored Procedures, CTE's (Common Table Expressions), Cursors, Views, Triggers, User Defined Functions and Scalar Functions.
• Performed discussions with data modeler to update the data model for new requirements.
• Extensively developed complex PL/ SQLpackages for Invoice Processing.
• Designed/developed tables, views, variousSQLqueries, stored procedures, functions.
• Involved in PL/ SQLcode review and modification for the development of new requirements.
• Extensively worked with DynamicSQL, Composite data types & Global Temporary Tables.
• Used PL/ SQLtables, array structures as a part of oracle collections.
• Create & maintained box jobs using Shell Scripts.
• Created ad Hoc and parameterized various reports usingSQLserver 2008 reporting Services
• Implemented multiple grouping into several reports using visibility and toggle options

Environment: MSSQLServer 2008R2, MS office 2010 T-SQL, Microsoft SSMS,SQLServer Integration Services, Microsoft Visual studio 2008, Team Foundation Server.

Confidential

SQL Developer

Responsibilities:

• Developed procedures, functions, packages.
• Used PL/SQL Tables and Records in transaction processing using the Oracle features.
• Implemented the Case Statement Logic in SQL statements to reduce the PL/SQL code using Oracle 9
• Extensively used IMP and EXP for data transfer from source systems to new application.
• Implemented the concept of Clusters to reduce the time of Data retrieval.
• Implemented Materialized view for faster processing.
• Worked with Clear case to track versions release control, to assign bugs to relevant developers and update status across the lifecycle.
• Wrote PL/SQL Stored Procedures, Functions and Packages.
• Created Database tables with complex constraints applicable to the business rules.
• Performed SQL Tuning within applications for optimized database access.
• Optimized database code using EXPLAIN PLAN.
• Created oracle objects (Tables, Views, Indexes).

Environment: Oracle 9i/10g, Oracle Data Integrator (ODI), SQL Server Management Studio 2008, PL/SQL, TOAD, SQL developer, SQL * Loader, SQL, UNIX shell scripting, MS Excel.