SUMMARY

• Over 7+ years of experience as Business Intelligence Developer using Microsoft BI Developer (SSIS, SSAS, SSRS) in various Business domains including Insurance and Information Technology
• Strong experience in client requirement analysis, physical, logical design development, resource planning, coding, debugging, testing, deployment, support and maintenance of business intelligence applications using SQL Server 2000/2005/2008/2012 , DTS, SSIS, SSRS and SSAS 2005/2008/2012.
• Hands on experience with SQL server and T - SQL in constructing joins, user defined functions, stored procedures, triggers, views, indexes, user profiles and data integrity.
• Expert in writing common table expressions (CTEs) and user defined functions, indexed views and DML/DDL triggers for data consistency and data manipulation.
• Primary knowledge in C# and ASP.NET
• Proficient in building Data Integration, Workflow solutions and ETL solutions for Data Warehouse using SQL Server Integration Services
• Extensive experience in migrating data from various sources such as Excel, Oracle, MS Access, MS SQL and flat files to different SQL destination servers using SSIS
• Designed and developed SSIS packages using Control Flow Tasks like For Loop Container, For Each Loop Container, ExecuteSQLTask, File system Task and Data Flow Tasks like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Multicast, Derived column, Union All, Merge Join.
• Experience in implementing logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
• Expert in Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS with MY SQL Server 2000, 2005, 2008 R2.
• Experience in developing and testing multidimensional databases using SSAS
• Experience in developing reports using SSRS and Excel
• Experience in creating Role based Security and Row level Security in cubes using SSAS.
• Experience in all phases of Software Development Life Cycle (SDLC) from requirements gathering, design, development and support of applications
• Strong mentoring skills, capable of leading and motivating individuals to maximize productivity while fostering cohesive teams in a virtual environment.
• Strengths include strong Project Management skills, Test Management skill, Business Analysis skills, Testing skills, Technical Analysis skills, Problem-solving expertise and good communication skills.
• Experience in writing MDX queries in Analysis Services and Reporting Services.
• Excellent analytical, debugging skills and research Flare.
• Excellent in interacting with clients, business analysts and developers.
• Good Knowledge in implementing backup and disaster recovery procedures.
• Good Knowledge in Relational Database Management Systems (RDBMS) and data warehouse concepts such as tables, user defined datatypes, indexes and indexed views.
• Primary Knowledge with Agile development methodologies.

TECHNICAL SKILLS

Programming Languages: SQL, Transact SQL, PL/SQL, C, C++, JavaScript, HTML, CSS, Swift

Database: MS SQL Server 2005/2008R2/2012/2014, MS Access

ETL Tools: SSIS, Import/Export Wizard, DTS(Data Transformation Services)

Reporting Services: SSRS, Power BI, Excel Reporting, Tableau

Analysis Tools: SSAS

Methodologies: Logical and physical Database Design, UML, Database Design, Normalization and Data Modelling

Business Processing Tools: MS Visio

Work Flow Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Access and MS Project

PROFESSIONAL EXPERIENCE

Confidential - Hoffman Estates, IL

MS SQL BI Developer

Responsibilities:

• Involved in gathering the user requirements
• Involved in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project usingSQLServer Integration services
• Created stored procedures, triggers, Joins, functions and views.
• Designed and developed SSIS packages
• Designed SSIS packages in order to validate, extract, transform and load data into to staging and data warehouse
• Created package to transfer data between OLTP and OLAP databases
• Deploy, schedule and support SSIS Packages.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing
• Responsible for performance tuning and optimization ofSQLqueries and indexes
• Created various complex reports and manage them usingSQLServer Reporting Services (SSRS)
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams
• Implemented logging, Error handling by using Event Handler and Custom Logging for SSIS Packages
• Used Agile development Methodology.

Confidential - Peoria, IL

MS BI Developer

Responsibilities:

• Analyzed Business requirements and created technical design
• Performed normalization and logical database design
• Created database links and accessed the data through SQL statements
• Responsible for writing and modifying store procedures, functions, packages and database triggers.
• Created indexes, tables and sequences as per the business requirement and views to maintain data privacy
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Analyzed the requirements and framed the business logic for the ETL process
• Developed, monitored and deployed SSIS packages on various servers using package configuration from test server to production servers
• Involved in building and testing OLAP cubes using SSAS
• Transferred data from sources like MS Excel, MS Access, SQL using SSIS and created reports for the same data using SSRS.
• Deployedanduploaded the SSRS reportstoReport Manager & SharePoint serverfor the end users and involved in enhancements and modifications.
• Involved in writing cursors in store procedures to perform row-wise operations
• Used SQL profiler to identify slow running queries
• Improved the performance of queries by using clustered and non-clustered indexes on tables.

Confidential - Chicago, IL

SQL Server Developer

Responsibilities:

• Created complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using T-SQL
• Involved in creating extensive dynamic SQL to accommodate business requirements
• Created extensive list of Sub queries, CTEs to speed up the queries
• Worked on Performance Tuning/Query tuning, execution plans, trace flags and SQL Profiler
• Used BCP Utility in Stored Procedures to generate Output Files in Text format
• Used scripts and variables, email notifications for ETL process using Data Integrator
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling
• Enhancing and deploying the SSIS packages from development server to production server
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008\2008R2.
• Created SQL Server Reports using SSRS 2008 in designing stylish report layout parameterized, performance and ad-hoc reports
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement
• Performed ETL operations to support the data loads and transformations using SSIS and used SSRS for generating reports to end-users

Confidential

SQL Developer

Responsibilities:

• Created Database Objects-Tables, Views, User defined functions, Triggers, Stored Procedure and Roles
• Created SSIS packages to get data from different sources, consolidate and merge into one single source
• Implemented different types of constraints on tables
• Monitored performance and optimized SQL queries for maximum efficiency
• Created levels of Data Flow Diagram using Microsoft Office Visio
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases
• Used complex queries to pull data from excel as well as other databases to the table that has been designed schema
• Optimized the performance of various stored procedures by redesigning T-SQL queries and changing connection and server level settings
• Performed Administrative tasks like managing roles, users, profiles and creating scheduling maintenances and backups to database
• Troubleshooting problems related with databases, application tools, development tools and minimizing production down issues

Confidential

Junior SQL Developer

Responsibilities:

• Involved in Physical and Logical design of the Databases
• Interacted with front end developers and managers to analyze the need of business requirement and developed technical specifications
• Developed DTS packages to transfer data between SQL Server Database and files
• Created Views to restrict the data access for security
• Used SQL Profiler to debug T-SQL and slow running queries
• Optimized the query performance with modifications in T-SQL, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database and establishing necessary joins