SUMMARY

• A SQL Developer with 8+ years of IT experience in database design, development and administration with MSSQL Server 2017/ 2016/2014/2012 /2008/2005 /2000 using SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS) in Insurance, Healthcare and Banking industries.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving System Requirements, Analysis, Design, Development, Implementation, Integration, Testing, Deployment and Maintenance.
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Experienced in ETL processes, Data warehousing methodologies and concepts including Star schemas, Snowflake schemas, Dimensional modeling, Reporting tools, Operations Data Store Concepts, Data Marts and OLAP technologies
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS ), Data Transformation Services (DTS), Bulk Copy Program (BCP)
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models, data integrity, SQL joins and query writing.
• Efficient in up-gradation and migration from MS SQL Server 2000 to MS SQL Server 2016/2014/2012 /2008/2005
• Experience in developing Custom Report, different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column and Data Conversion Transformations
• Experience in using Audit functions and extensively used Exception Handling for catching and reporting errors
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Joins, Indexes, Data Import/Export, Triggers.
• Proficient at data transformations like lookups, Derived Column, Conditional Splits, Sort, Data Conversation, Multicast and Derived columns, Union All, Merge Joins, Merge, Fuzzy Lookup, Fuzzy Grouping, Pivot, Un-pivot and SCD to load data in SQL SERVER destination.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Worked on Scrum Methodology as well as on SDLC procedures in the implementation of Tableau and Spotfire.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem-solving skills.

TECHNICAL SKILLS

Languages: Transact SQL, PL/SQL, XML, C, Visual Basic 6.0, Java, and HTML.

Databases: SQL Server 2016/ 2014/2012/2008/2008/2005/2000 R2,MS Access, Oracle 9i, Oracle 10g, MySQL, DB2

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

ETL Tools: DTS, SSIS, Data Stage, Informatica, Bulk Copy Program (BCP), Business Intelligence Development Studio (BIDS), Crystal Reports 9/10/11

Data Modeling Tools: Erwin, Microsoft Visio

Operating Systems: Windows 98/XP/NT/ 2000/2003/2008/10 , UNIX, LINUX, Mac OS

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio (SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. SQL Server Developer

Responsibilities:

• Responsible for technical design, development, coding, testing, debugging and documentation of databases and database applications to satisfy requirements of one or more user areas.
• Responsible for creation of data services and integrating the data service components.
• Collaborate with other developers in creating optimal, maintainable, and scalable architecture and design and actively promote quality in coding and other project activities.
• Create high quality, detailed technical documentation on the whole database for the Current Project.
• Responsible for the segmentation which runs daily where individual opens, clicks will be updated every day.
• Responsible for the database for the current project, where data is dumped into the database and scrubbed into the correct format per the requirement given by the client.
• Extensively used Joins and sub Queries to simplify complex queries involving multiple tables.
• Responsible for enterprise level solutions development including data warehousing, data marts and/or software applications.
• Responsible for high performance of data architecture and design including Star Schemas, Snowflake Schemas, and Dimensional Modeling.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.
• Developing complex SSIS packages using different data transformations like Aggregate Conditional Splits, Lookup, Sort, Merge Join, Data Conversions, Derived Columns, Multicasting, Slowly Changing Dimensions, Scripting, OLEDB Command with SQL etc.
• Developed CTE's, Constraints, and Complex queries to fetch the data from different servers.
• Actively involved in writing SQL Stored Procedures, functions, and triggers for updating customer usage information in the database.
• Developed several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS and Excel.
• Monitored the jobs run using Informatica Workflow Monitor and used to debug the job by setting up the log files and bad files.
• 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.
• Implemented the changes/modification like iterative/incremental development and used .NET Framework and Object Oriented Methodologies for application development by using agile scrum methodology.
• Maintained Source definitions, Transformation rules and Target definitions using Informatica Repository Manager.
• Developing SSIS packages that upload multiple flat files using for each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task, Script Task etc.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and implemented stored procedures and triggers for automating tasks.
• Built ETL workflows using Informatica tools to extract the data from feed files (with the formats like XML, TXT, DAT, XLS, Message Queues, etc.,) and load them into staging area and then to Data Warehouse.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a date.
• Built different data visualization by using Power BI to turn data into charts/maps.
• Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to a diverse group of users, clients, and managers.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to a diverse group of users, clients, and managers.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.

Environment: SQL Server 2016/2014/2012 , Clustering, SSIS, SSRS, T- SQL, Visual BasicsVisual Studio 2012/2015, Indexes, Cluster, Informatica, .Net Framework 3.5, MS Office suite 2011

Confidential, Pekin, IL

Sr. SQL Server/Database Developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse.
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript
• Migrate the data from an Access database to SQL Server 2008.
• Fetch the data from Oracle 10g by creating a linked server and use SQL Server to query Oracle database.
• Designed the packages in order to extract data from SQL db, flat files and loaded into Oracle database.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2008.
• Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
• Reports in both SQL and reporting tools such as Crystal Reports and Business Objects
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: SQL Server 2014/2012/2008/2005/2000 R2, T-SQL, SSRS, SSIS, SSAS, Visual Studio 2008MS Office 2007/2003, MS VSS, XML, MS SharePoint 2007