SUMMARY

• Over 8 years of IT experience as a MS SQL BI Developer with an experience in MS Visual Studio 2014/2012 2010/2008/2005 , MS SQL Server Developer 2014/2012/2008/2008 R2/2005 in Domain such as Finance, Insurance and HealthCare.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services. Good knowledge and experience in COSMOS.
• Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Expert in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS) to perform data transfers from OLTP to OLAP, different server locations and heterogeneous sources like Oracle, Excel, XML, CSV, flat file, Text Format Data.
• Expert in creating SSIS Packages using Pivot Transformation, Fuzzy Lookup, Fuzzy Grouping, Derived Columns, Condition Split, Execute SQL Task, Data Flow Task, Execute Package Task, Slowly Changing dimensions etc. to generate underlying data for the reports and to export them as per the requirement of the client.
• Extensive experience in creating Parameterized, Linked, Tabular, Matrix, Drilldown, Drill through, Subreports and Ad hoc reports using SSRS. In depth experience in creating multiple levels cascading prompt for both static and dynamic parameter.
• Expert in generating periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS 2014/2013/2012 2010/2008/2005.
• Excellent work experience as Report developer and Report Analyst with in-depth knowledge in working and implementation of Crystal Reports versions 2008/XI/10/8.5.
• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS)
• Expert at Logical and Physical Database design and development, Normalization and data modeling using Erwin and Microsoft Visio and the use of SQL Server Enterprise Manager.
• Responsible for writing functional specifications, translating business requirements to technical specifications, created/maintained/modified database design document with detailed description of logical entities and physical tables.
• Proficient in database performance optimization, debugging and tuning using the Execution plan, SQL server Profiler and Database Engine tuning Advisor.
• Strong experience in logical and physical database design and development, Normalization and data modeling and star schema design as well as snowflake schema design using CA Erwin and MS SQL Server Enterprise manager.
• Expertise in using Team Foundation Server used for the Team Projects which allows multiple users to work on same project at the same time. Different versions of the projects can be captured using the functionality.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Recovery procedure and involved in the migration and upgrade of databases.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.
• Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes and overall development of Data Mart.
• Experience in Seting up AlwaysOn Availability Groups for HA and DR solutions on SQL 2012.
• Highly involved in Database migration from 2000 and 2005 to 2008 R2 and to 2012.

TECHNICAL SKILLS

SKILLS: .NET, C#, HTML, MICROSOFT SSRS, MS SQL Server

Operating Systems: Windows XP/Vista/ 2007/2008/2010 , Windows Servers 2003/2008/2012 , UNIX

Languages: C/C++, C#, ASP.Net, VB.Net, XML, HTML, T-SQL, PL/SQL

Databases: MS SQL Server 2014/ 2012/2010/2008 R2/2008/2005, CRM, Oracle 8i/9i/10g, Sybase, MS Access, DB2

ETL Tools: SQL Server Integration Services (SSIS), DTS

Tools: /Utilities: Enterprise Manager, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS) 2014, Business Intelligence Visual Studio 2014, SSAS, ERWIN, Microsoft Access 2013/2010/2007/2003 , Microsoft Excel 2013/2010/2007/2003 , Power Point, MS Visio 2003/2007, MS SQL Profiler, TOAD (for Oracle), VSS (Visual Source Safe), MS SharePoint Services Reporting Services SQL Server Reporting Services (SSRS), Crystal Reports 8.5, Tableau 9.0, Business Object.

PROFESSIONAL EXPERIENCE

Sr.Microsoft BI /SQL/Infrastructure Developer

Confidential, Chicago, IL

Hardware/Software: MS Visual Studio 2012/2010, MS SQL Server 2012/2010/2008 , T-SQL, SSIS, XML, HTML, VB.Net, C# Net, ASP. Net, Remote Desktop, VPN, DB2, Access, Oracle 11g, aqua data studio 14.0, WinSQL, WinSCP, SQL Plus

Responsibilities:

• created different dimension and fact table as per business requirement using dimensional data model. created processes to load data into warehouse from different sources using SSIS. used different customize interface for Netezza and cache and different transformation for data cleansing before loading to data warehouse.
• Developed Framework to automate the ad-hoc report generation for different business team.
• Created Matrix, drill down, drill through, sub and linked reports using MS SSRS 2010 as well as managed the standard and data driven subscription of the reports.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented complex Business Logic using Temp table, Table variable, Function and Common Table Expressions (CTEs)
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
• Played a role in design of scalable, reusable, and low maintenance ETL templates. Created generic Packages to use in multiple packages.
• Involved in designing ETL as a part of Data warehousing and loaded data into staging table for further data utilization using SSIS.
• Formulated and documented the physical ETL (SSIS) process design based on business requirements and system specifications with strong ETL (SSIS) design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Transformed complex business logic into database design and maintaining it by using SQL objects like store procedures, User defined functions and Views.
• Configure SSIS Email attachment task for sending automated alerts/email with Alerts for successful or unsuccessful completion of SSIS packages with appropriate error message.
• Worked on Database migration from 2005 to 2012 and Highly involved in setting up High Availability and disaster recovery environment for the production servers.
• Actively involved in setting up new non-Production environment for development and testing purpose.
• Generated Ad-Hoc reports as per the Business requirements using complex business logics.

Sr.SQL Server/SSRS/SSIS Developer

Confidential, Cherry Hill, NJ

Hardware/Software: MS Visual Studio 2014/2012, MS SQL Server 2014/2012, T-SQL, SSRS, SSIS, XML, HTML, VB.Net, C# Net, ASP. Net, Remote Desktop, VPN, DB2, Access, Oracle 10g, Erwin v8.0

Responsibilities:

• To migrate data from Heterogeneous data Sources and legacy system to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more.
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Performed ETL mappings using MS SQL Server Integration Services.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Developed complex SQL queries or stored procedures used by reports to retrieve information from relational database and data warehouse
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
• Experience in creating SSAS based OLAP Cubes.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Performed data conversion from flat file into a normalized database structure.
• Create Common Table expressions (CTE) and temp tables to facilitate the complex the queries in T-SQL.
• Good experience in creating T-SQL Server database objects like tables, views, procedures, functions and triggers for a project.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2014.
• Involved in table and index partitioning for performance and Manageability.
• Developed Query for generating drill down and drill through reports in SSRS.
• Created dashboards for Sales, Marketing, Finance, Account and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Dynamically produce reports on outstanding accounts that require attention.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish layouts for Managerial accounting reports.
• Keeping track of the features and bug fixes being deployed and producing issue logs.
• Maintained data marts up-to-date and in accordance with company's requirements and practices.

SQL Server/SSRS/SSIS Developer

Confidential, Boston, MA

Hardware/Software: MS Visual Studio 2014/2012, MS SQL Server 2014/2012, T-SQL, SSRS, SSIS, Tableau 9.0, Crystal Report 9.0, XML, HTML, VB.Net, C# Net, ASP. Net, Remote Desktop, VPN

Responsibilities:

• Responsible for managing and executing SSIS packages to transform the data from the different vendors.
• Designed and developed SSIS package for loading data from previous database schema versions into current schema versions.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Extensively involved in writing TSQL scripts for scoring Retention models, pricing models, Claims Models.
• Create relational data model for the factors and variables for different models. Create a high level dynamic script to handle all the scores using a single query.
• Adjust the security levels for the users to access the reports. Create Windows account to allow the users to access the reports.
• Involved in building report models in order to access them by the analysts over the web through SQL 2014 report builder.
• Create TSQL scripts to transfer the data from excel, CSV and production servers to development server for further use.
• Designed and Implemented Tables, Functions, Stored Procedures and Triggers in SQL Server. Wrote the SQL queries, Stored Procedures and Views in T-SQL.
• Formulating SQL queries and stored procedures on assigned modules
• Configure SQL Agent jobs to run the stored procedures on a regular basis.
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler.
• Generated reports using SSRS, Crystal Reports and Tableau from both OLTP and OLAP data sources.
• Involved heavily with SQL Server stored procedures, triggers, database schema on several web based applications. Used stored procedures and views for all of the ASP.NET web applications.
• Developed medium to complex reports like detailed list report, summary reports, Matrix reports, drill through reports, Sub-reports, ad-hoc reports to meet various business needs using SSRS. Also developed a report which included Geographical map of USA.
• Involved in Business Intelligence design including Entity Relationship Diagrams, Data Modeling, Systems Design, and User-Interface Design.
• Created Database Objects: Tables, Index, Views, User Defined Functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Analyzed the query used for access reports, converted into T-SQL and fixed errors using MS SQL Server 2012.
• Involved in writing positive and Negative Test cases, and unit testing for the Reports.
• Keeping track of the features and bug fixes being deployed and producing issue logs.
• Created Map, Drill down and Bar charts Reports for Retention, Policy life and DNQ rate using Tableau.

Database Developer

Hardware/Software: MS Visual Studio 2005/2008, C# Net, T-SQL, SSIS, SSRS, HTML, Remote Desktop, DTS

• Installing, configuring, administering and securing production SQL servers. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Created documentation as required. Writing SQL Scripts for modifying and accessing Data
• Created Accounts payable reports, Invoice aging Report for Finance Department.
• Involved in the requirement analysis, design and development.
• Installation and Configuring of Microsoft Outlook 2000 for Send Mail for Local E-mails on Clients.