SUMMARY:

• Around 4+ years of IT industry experience with Microsoft BI & SQL Server 2000/2005/2008, SSIS/SSRS as SQL Developer.
• Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.
• ‘Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML), which includes Use Cases, Sequence, State and Activity diagrams, Data mapping, participated in architectural design and class design.
• Hands on experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star, Snowflake, Normalized and De - Normalized Schemas with respect to query and analysis requirements.
• I have been working on Sql Server OLAP & OLTP Databases, Sql Server Integration Services (SSIS),
• Reporting Services (SSRS), Analysis Services (SSAS), Power BI (Power View, Power Pivot)
• Query, Power Map), SharePoint, Datamining, MDX, DQS, strong background in SQL stored procedure development and triggers.
• I started working with Sql server 2005 and currently working on Sql Server 2012 SP2.
• I am very strong in Tsql and design the tables that have 1-many & many-many relations.
• My day-to-day work involves designing & Implementing SSIS Packages, SSRS Reports & PowerPivot
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Expert in working with Business Intelligence Development Studio (BIDS), that includes SSIS, SSRS.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Expertise in developing reports using SQL Server Reporting Services and MS Excel spreadsheets.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Sub reports and formatting them using both SSRS 2005/2008.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Worked on .Net framework 4.0 and Asp.net as a programming part.
• Maintained and implemented technical specification and documentation .
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver Reports.

TECHNICAL SKILLS:

RDBMS: Microsoft Access, MySQL, DB2

Programming Languages: C, TSQL, Java

Web Technologies: HTML, XML, ASP.Net

Database Tools: SQL Server Management Studio (SSMS), MySQL, Microsoft Access, SQL Server Business Intelligence Studio (BIDS),, SQL Server Development Tools (SSDT), SQL Profiler, Query Analyzer, Enterprise Manager

ETL Tools: SQL server Integrating services (SSIS)) 2005, DTS

Reporting Tools: SQL server Reporting services (SSRS) 2005, SQL server Analysis services (SSAS) 2008, 2005

Data Modeling: Erwin, MS Visio

Other tools: Visual Studio .NET.

PROFESSIONAL EXPERIENCE:

Confidential,Farmington Hills,MI

POWER BI/ SQL BI Developer

• Involved in complete Software Development Life Cycle (SDLC).
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, 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.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Created and maintained the stored procedures, triggers, cursors, complex joins, sub queries involving multiple tables to interpret complex business rules.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2014 and Flat files.
• Involved in daily loads (Full & Incremental) into Staging areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• 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.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Developed a High level dashboard using SSRS 2008.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential

MSBI Developer

• Actively participated in gathering of User Requirement and system specification.
• Developed stored procedures, views and User Defined Functions using T-SQL statements.
• Installed and Maintained MS SQL Server 2000/2005.
• Involved in creating clustered and Non-Clustered Indexes to improve the database transactions performance.
• Maintained the table performance by following the tuning tips like Normalization, creating indexes and collect statistics.
• Responsible for Design and Normalization of the database tables.
• Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Rebuilding the indexes at regular intervals better performance.
• Written various stored procedures for the purpose of application development.
• Design and implemented data access stored procedures and triggers for automating tasks.
• Used joins and sub-queries to simplify complex queries involving multiple tables.
• Worked on crystal reports with many complex stored procedures.
• Created multi-format reports using Crystal report.
• Worked on importing /transferring the data to database tables using DTS, Import and Export Utility.
• Created and automated regular jobs Daily/weekly Report Generations.
• Monitored Performance and optimized SQL queries for maximum efficiency.
• Support for Database programming related issues.

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, JavaScript

Confidential

SQL Server Developer

• Setup new MS SQL Server 2000 instances and databases.
• Implemented and maintained database security.
• Going through the clients requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Worked to Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Written many Stored Procedures and Triggers as per client’s requirements.
• Running DBCC consistency checks and fixing data corruption in applications databases.
• SQL query development using Oracle and Confidential Redshift
• Creating data visualization dashboards
• Gathered requirements from stakeholders to build ad-hoc reports
• Development of dynamic SQL queries (subqueries, stored procedures, functions, ETL packages)
• Ensured data accuracy and integrity
• Coordinated with multiple teams to build business use cases for report development
• Project Management.

Environment: MS SQL Server 2008/2005 SSIS, SSRS, SSAS, Visual Studio 2008, T- SQL, Windows 2000/2003 Server, Visual Source Safe, XML, ADO.NET, ERWIN, PL/SQL, MS-Access, MS-Excel.