SUMMARY:

• 8+years of experience in the analysis, design, development, implementation, testing, maintenance, and documentation of Database and Client Server applications.
• Expertise in SQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services(SSAS)
• Involved in Huge data migrations, transfers using utilities likeData Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in complete Software Development Life Cycle (SDLC) - requirements gathering, conceptual design, analysis, high and low level detailed design, development, system testing.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Ad-hoc reports using SSRS. Installed, configured and maintained SSRS server.
• Experience in providingLogging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL & MS SQL Server 2005/2008/2008 R 2/2012/2014/2016 and MS Access databases.
• Experience in installation, configuration, Development of MS SQL Server 2005/2000/2008/2008 R 2/2012/2014/2016 Reporting Services.
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SSRS.
• Good knowledge on Performance point services and worked on few Performance Point Dashboards.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2/2012/2013 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Good experience in MDX scripting and created Multi-dimensional expressions using MDX scripting.
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, Validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
• Very good experience with ETL (Extract, Transform, Load) processes for OLTP & OLAP environments Experience in Reporting Services (SSRS 2000/ 2005/2008/2008 R2), Crystal Reports & Integration Services (SSIS).
• Report Service experience with Microsoft Excel Power Pivot.
• Good knowledge on C# and also in Web technologies such as HTML, DHTML and XML.
• Experience in configuration of report server and report manager scheduling, permissions to different level of users in SQL Server Reporting Services (SSRS).
• Excellent communication skills, analytical skills, understand business requirements in various domains.
• Quick learner and good performer both in team and independent job environments.
• Experience in working on Dash boards using COGNOS Tool, like web-based reports, scorecards, and dashboards.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager, Ad-hoc reports, data driven subscription reports by using Report Builder.
• Experience in developing Dashboard, Parameterized Reports, linked reports, Sub reports, created complex Reports (ex: drill down reports using different objects), drill through reports using SSRS.
• Knowledge of Data Modeling (Logical and Physical Design), Normalization and De-normalization as required of the large-scale OLTP/OLAP databases.\
• Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies, and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Familiar with database normalization in database designing. Adept in creating ER diagrams and mapping the data into database objects.
• Worked on Multidimensional Expressions (MDX) queries on Cubes.
• Experience working on object-oriented concepts working on C#.Net.
• Good knowledge in Oracle 11g/10g/9i/8i
• Integrator of relational databases like SQL Server, ORACLE, Microsoft Access, and Excel spreadsheets.
• Excellent communication, presentation, interpersonal skills.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server integration Services(SSIS), Microsoft SQL Server Reporting Services (SSRS), SQL Server Management Studio(SSMS), SQL Server Business Intelligence Development Studio(BIDS), SQL Server Enterprise Manager, Microsoft management Console, Data Transformation Services (DTS), DTSX, Team Foundation Server(TFS), SQL Server Analysis Services (SSAS), OLTP, OLAP

ETL: SSIS, BCP, Import/Export Wizard, BI Studio

Reporting Tool: SSRS, Crystal Reports, Tableau, Power BI

T: SQL, C, C#, .Net, PL/SQL, HTML, Python.

Databases: MS SQL Server 2005/2008 R2/2012/2014, Oracle 9i/10g/11g, SQL & MS Access

Data Modeling Tool: Erwin, Microsoft Visio,performance point server, Power Pivot.

Operating System: Microsoft Windows 95/98/2000/2002/ Vista/Windows7/Windows 8/10, Mac OS X

PROFESSIONAL EXPERIENCE:

Confidential, Wood Dale, IL

BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, designed complex reports from different data sources such as SQL Database and Cubes.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2012/2014 and Flat files
• Created different kind of reports like List reports, cross tab reports, charts, Drilldown reports, Drill through Reports, Parameterized reports, Sub reportsas well as managed the subscription of the reports (Standard and Data-Driven Subscriptions).
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Creating & publishing the packages according to the business requirements and also involved in the scheduling and deployment of the reports.
• Created ETL packages using SSIS to extract data from relational database and then transform and load into the datamart
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files and SQL Server.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created and maintained SSIS ETL packages to extract data from different sources consolidate and merge into one single source using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created Staging database for temporary processing of data, consolidating data and loading database using Integration Services.
• Scheduled jobs to execute SSIS packages, which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from SSIS to make the flow of SSIS effective.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012/2014.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-hoc reports as per the client requirements.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Created SQL Server Reports using SSRS 2012/2014.Identified the data source and defined them to build the data source views.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Transformed and combined the data using Query Editor in thePowerBI.
• CreatedPowerBIVisualizations and Dashboards as per the requirements.
• Worked on creating and maintaining SSAS Databases which includes creating new Cubes, Dimensions, and Calculated Measures, Partitioning and building MDX queries.
• Utilized Microsoft team foundation server (TFS) to manage the teams software development lifecycle.
• Involved in the Unit Testing of the reports and preparing the Test cases
• Used GitHub for version control, source control and reporting

Environment: SQL Server 2016, SSRS 2016, SSIS, SSAS, MS SQL Server 2016 Management Studio, T-SQL, MDX, Power BI, Visual Studio 2013,Stored Procedures, GitHub and Microsoft Excel.

Confidential, East Lansing, MI

BI Developer

Responsibilities:

• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Involved in system study, analyze the requirements by meeting the client and designingthe complete system.
• Responsible for identifying client and organizational needs and providing suitable system based solutions.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2008/2012.
• Generated SSRS Reports involving different features like Reports, Sub-Reports, Drilldown, Drill-Through, Charts, Filters, Multi-valued parameters and linked reports in SSRS.
• Involved in developing ETL for loading data into Database.
• Created SSIS Packages to load variety of large volume data into data warehouse from different sources like CSV files, Text files and Excel Spreadsheets.
• Creating Packages on SSIS by using different Data Transformations like Derived Column, Conditional Split, Pivot, Multicast, Sort and Execute SQL Task to load data into data warehouse.
• Used SQL server reporting services (SSRS) delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
• Designed and created report models based on users’ requirements, explained and trained users to use report builder to generate their own personalized reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2012/2008.
• Attended status meetings and took active role in initiating bug triage meetings when necessary.
• Facilitated Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
• Created and executed SQL queries and scripts to validate data movement and generate expected results for UAT.
• Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy & Dimensional modeling. Backup & recovery.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Created Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Perform Business Process Automation (BPA) to reduce operational costs and enhance quality of customer deliveries.
• Maintain SVN repository, deploy code base to QA, UAT, dry-run environments as requested.

Environment: SQL Server 2012/2008, SSRS 2008/2012, SSIS, MS SQL Server 2008 R2 Management Studio, Stored Procedures, Tortoise SVN,Agile Methodology, C#, T-SQL, Microsoft Excel.