SUMMARY

• Overall 8 years of ITexperience in data designing, data modeling, development, implementation and Support of SQL Server and SQL Server Services (SSRS/SSIS/SSAS).
• Expertise in design optimizing various T - SQL database objects such as tables, views, stored procedures, user defined functions, cursors, indexes and triggers.
• Expertise in reporting using Crystal Reports and SQL Server Reporting Service (SSRS).
• Experience in using SQL Server Management Studio & SQL Profiler.
• Experience in data modeling (logical and physical designing of databases), normalization and building referential integrity constraints.
• Experience in data integration and creating workflow and ETL solutions for data warehousing using SSIS.
• Skilled in error and event handling: Precedence Constraints, Break Points, Check points and Logging.
• MigratedSQL Server from 2000 to 2005 & 2005 to 2008 running and scheduling SSIS packages, Look-up for cleaning unwanted data, validating data using SSIS.
• Designed and mapped using various SSIS Transformations like OLEDB command, Conditional Split, Aggregate, Multicast and Derived Column.
• Created configuration files to deploy the SSIS packages across all environments.
• Used multiple transformations and integrations in SSIS to meet the business requirements by collecting data from heterogeneous sources like Excel, CSV, SharePoint List, flat file to SQL Server databases using SSIS.
• Extensively worked on developing Custom Report and various types of tabular reports, matrix reports, ad hoc reports and distributed reports in multiple formats using SSRS.
• Worked on report manager for deploying the reports across all the environments.
• Expertise in using global variables, expressions and functions to create reports.
• Experience in installing and configuring Reporting Services and assigning permissions to different levels of users in SSRS.
• Created ad-hoc, parameterized reports, linked reports, snapshots, drilldown and drill through reports using SSRS.
• Experience working wif Tableau Desktop BI application for data visualization and Tableau Server.
• Implemented indexes (clustered & non-clustered) on tables and views to optimizethe performance.
• Experience in providing high quality application support on data integration and data management.
• Excellent oral and writing communication skills wif a results-oriented attitude.
• Knowledgeable in Collecting, Analyzing and Interpreting Data in an organized way.
• Able to quickly learn and apply new concepts efficiently.
• Able to work on multiple projects Confidential a time in parallel utilizing technical and functional expertise.
• Self-motivated and highly capable of working individually or in a team environment varying from small to large team size.

PROFESSIONAL EXPERIENCE

Confidential - Livonia, MI

Sr. SQL/SSIS/SSRS Developer

Responsibilities:

• Used SSISto load and optimize solutions from multiple data sources such as MS Access, Oracle, Excel and flat files.
• Experience dealing wif large complex data sets across multiple sources.
• Source Data provisions for Models using SSISand troubleshooting SSIS packages for any ETL issues.
• Developed vendor and client exports that meet provided specifications.
• Performed installation, configuration, design, implementation of staging database for data migration and data storage.
• Developed highly complex T-SQL Queries and SQL Scripts.
• Experience wif analyzing, debugging and tuning SQL databases queries for performance improvements.
• Designing and creating SQL queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Data migration using import and export procedures from Excel to SQL server.
• Used multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Secured and Configured SSIS packages for deployment to production using Package configurations and Deployment Wizard.
• Performed SQL Database administration, data backups and restoration etc.
• Writing complex calculations, functions &stored procedures for reports, and optimizing existing procedures using indexing, temp tables, logic changes, etc.
• Generated various complex reports and manage those using SQL Server Reporting Services.
• Created Tabular reports, Matrix reports, List & Chart reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Supporting business users for various requirements and developing multiple reports accordingly.
• Produce project plans, architecture diagrams, technical and training documentation as required by management.

Confidential - Dearborn, MI

Sr. MSBI Developer

Responsibilities:

• Interaction wif business analysis teams to gather requirements for reporting and analysis.
• Responsible for designing and deploying Reports based on client requirements using SSRS and Web Interface.
• Designed, developed, managed and scheduled various SSIS Packages.
• Created, implemented and maintained a reporting suite of over 72 standard reports while also customizing many reports to meet individual business needs.
• Responsible for generating Tabular, Parameterized (single, multi), Drill through & Drill down, Map, Gauge, Matrix and Sub Reports in SSRS wif PDF, XLS and CSV Formats.
• Created solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms using Tableau Desktop BI.
• Created Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages.
• Involved in huge data migration and transfers using utilities such as Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Created new Informatica environment, repositories, users, users group, granting the permissions, creating relational connections, scheduling the jobs for development and production environment.
• Planning and maintaining sufficient memory on Informatica application servers across the grid for better ETL Load performance.

Confidential - St Louis, MO

Sr. SSIS/SSRS Developer

Responsibilities:

• Designed and created databases, database objects based on the business requirements.
• Involved in creation of new database, planning the location of data, index and transaction log files on the disks.
• Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Designed Tables, Constraints, Views, and Indexes etc. in coordination wif the application development team.
• Involved in create table-valued functions.
• Used joins and sub queries to simplify complex queries involving multiple tables.
• Provided technical support to move databases from development to test and production for multiple applications.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Created SSIS packages to transfer XML file data into SQL server database.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application.
• Improved performance of SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Worked wif SQL server profiler to generate traces.
• Created SSIS script tasks, Look up transformations and Data flow tasks using T- SQL, C# and Visual Basic scripts.
• Writing the stored procedures, checking the code for efficiency, routine backups and restoration.
• Used SQL server Business Intelligence Development Studio to designs SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do dis task periodically.
• Creating and modifying T-SQL stored procedures/triggers for validating the data integrity.
• Designed ETL packages dealing wif different data sources (SQL Server and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Scheduling and deploying reports using SSRS to generate monthly and quarterly reports including current status.
• Createddatasets and usedexpressions in SSRS.

Confidential - Dallas, TX

SSRS/SSAS BI Developer

Responsibilities:

• Responsible for gathering and documenting the business specifications. Developing reports using SSRS to meet business specifications.
• Planned and prepared technical specifications, designed and created DTS Packages.
• Responsible for creating appropriate loaders and relational writes to load the Data from SSIS. Creating jobs for scheduling the SSIS packages.
• Integrating data from different data sources. Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, etc. ETL these data into data warehouse such as SQL Server.
• Used transformations like Derive Column, Conditional Split, Aggregate, Row count, sort and execute SQL Task to load data into Data Warehouse.
• Generated custom and parameterized reports using SSRS/SSIS.
• Creating datasets wif Stored Procedures. Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Created reports that call sub reports in SSRS. Identified the dimension, fact tables and designed the data warehouse using SSAS. Created reports that call sub reports in SSRS.
• Actively involved in developing Complex SSRS Reports involving Sub reports, Matrix/Tabular Reports, Charts and Graph

Confidential

SQL Developer

Responsibilities:

• Created various T-SQL database objects such as tables, views, stored procedures, user defined functions, cursors, indexes and triggers.
• Debugged the processes, triggers and views, monitored the system and SQL server job schedule and recorded errors.
• Maintain and enhance the existing data warehouse, exports, and reports.
• Monitored processes for different data loads and resolved issues.
• Analyzed the performance, tuned, optimized and supported database objects to migrate to production, executed stored procedures and index sizing.
• Prepared presentations for end user training and manuals to perform operations using database.
• Debugging to fix existing issues in the system and writing code for enhancement.
• Enhancement to address issues wifin the functionality of the product wifout affecting the other functional areas.
• Experience wif full software development cycle of a data warehouse, including requirements gathering, design, implementation, and maintenance.
• Modified and simplified the Codes/Stored Procedures to decrease run time and reduce database space usage.