SUMMARY:

• Knowledge of complete software development life cycle (SDLC) including Requirement Analysis, Requirement, Gathering, Design, Development, Implementation and Testingand Development experience.
• Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, user authorizations and database creation.
• Involved in Transformation and Loading (SSIS), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes.
• Worked with Business Analysts, Web development team and users on database solutions.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Well versed with the knowledge of RDBMS, data warehousing i.e. OLTP & OLAP systems.
• Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Experience in extraction, transformation and loading (ETL) of data flows using SSIS with complex integration of SQL Server, oracle, flat file sources and IBM mainframe DB2.
• Expertise in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency.
• Proficient in Resolving Complex Issues and Error Handling in SSRS, SSIS.
• Well - organized, goal-oriented, highly motivated effective team member with excellent analytical, strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.

TECHNICAL SKILLS:

DBMS/RDBMS: MS-SQL Server 2016,2012,2008R2

ETL: SQL Server Integration Services(SSIS), SQL Server Import/Export wizard

Report Tools: SQL Server Reporting Services (SSRS), Power View

Data Modeling: SQL Server Analysis Services (SSAS)

Languages: T-SQL, XML, C#

Operating System’s: Windows server 2013/2008/XP/Vista, Windows 7/8

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio

Office Tools: MS Word, PowerPoint, Excel, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Carrollton, TX

SQL Server SSIS/SSRS ETL Developer

Responsibilities:

• Experience on creating, troubleshooting and using various complex stored procedure, triggers, Functions, views, Transactions, joins, Cursors, Indexes etc which have utilized for SSRS, SSIS and SSAS.
• Created and modify all the needed stored procedures, user defined functions, scripts, and SSIS packages to extract, transform and load (ETL) the data from several data sources to MS-SQL Server Data Warehouse.
• Responsible for enhancements, maintenance and monitoring of the data warehouse on SQL Server and the daily ETL Process.
• Analyzed source system data to determine the data model and ETL solution that will meet business requirements.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For each Loop Container, Execute SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Created scripts to massaging, scrubbing and cleansing of legacy data in staging area.
• Extensively used C# script component in SSIS packages.
• Write Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.
• Created, Process, Partitioned the cubes using SSAS.
• Created various Stored Procedures to validate the data from the source and update/insert the records into target tables.
• Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans.
• Created technical specifications, test plans and test data to support ETL processes.
• Generated the reports in SSRS using MDX.
• Work closely with Report analysts and operation staff for support in problem resolution and root cause analysis.
• Created/monitored scheduled data warehouse jobs using SQL Server Agent jobs.
• Worked with users and business analysts to design and develop tabular, matrix, gauges, chart, drill down reports as well as interactive reports according to business requirements.
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and manage subscriptions.
• Participated in AGILE iterative development methodology.

Environment: MS SQL Server 2012, Reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), Microsoft Excel.

Confidential, Brookfield, WI

SQL Server SSIS\SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of data source and data flows.
• Installed and configuredSQLServer 2012 andSQLServer Reporting Services.
• Created and maintained database objects (tables, stored procedures, and views).
• Optimized the performance of queries with modification in T-SQLqueries, normalized tables, established joins, and created indexes.
• Experienced in working with many complexSQLqueries using joins and date functions to generate various reports.
• Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports.
• Developed drilldown, drill through, parameterized, and Ad hoc reports and charts using SSRS.
• Advanced extensible reporting skills usingSQLServer 2008 Reporting Services (SSRS). Created many complex stored procedures/functions and used them inSSRSdirectly to generate ad-hoc reports.
• Processed and generated manual reports for the end business users on a daily, weekly, and monthly basis.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema and snowflake schema.
• Designed and developedSSISPackages to import and export data from MS Excel,SQLServer 2008 and Flat files.
• UsedSSISto create ETL packages to validate, extract, transform and load data to data warehouse databases
• Worked with different Control flow tasks in creatingSSISpackages especially For Loop and For Each Loop containers with ExecuteSQLand Script Tasks.
• Create stored procedures comprising of dynamic scripts using Bulk Insert, Insert and Update tasks to copy data from multiple flat files toSQLserver staging tables.
• Designing a data structure with multiple facts and dimension tables to hold the source data to be used for building new reports withSSRS.
• Involved in daily loads (full & incremental) into staging and ODS areas, troubleshooting process, issues and errors usingSQLServer Integration Services (SSIS) 2008.
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, aggregate, multicasting, conditional split and derived column.
• Built multi fact table cubes using SSAS.

Environment: MS SQL Server 2012/2008, Reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), T-SQL, MS Excel.

Confidential, Milwaukee, WI

Account Manager

Responsibilities:

• Marketing/communications strategy development.
• Execute/develop Below-the-line (BTL) activities.
• Develop market survey/scans on targeted consumer products.
• Media buying (negotiations) and planning.
• Source out suppliers/sub-contractors and supervise all ATL/BTL supply.
• Report writing.