SUMMARY

• 8+years of IT experience in Database Development, Administration, System Analysis, Design, Development, implementation and support of MS SQL Server 2005/2008//2008 R2/2012.
• Extensive Experience in Data Modeling, ETL (Extract, Transform and Load), Database Design, Development and Reporting.
• Expert in developing T - SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues.
• In-depth knowledge in ER Modeling and Dimensional Modeling (Star and Snowflake Schema) building Dimension and Fact tables
• Extensive experience with all phases of Software Development Life Cycle in different environments like Banking, Insurance, Engineering and Information Technology.
• Knowledge in Agile, Scrum, UML, Waterfall and Project Management Methodologies.
• Extensive experience with SQL Server in production and development environmentsand T-SQL in constructing tables, user defined functions, relational database models, triggers and data integrity.
• Supported and developed various Client Server applications by handling Database requests for various application development teams.
• Good knowledge in creating, modifying, using and debugging Stored Procedures, Views, Indexed Views.
• Experience in building Referential Integrity Constraints, Normalization and Data Modeling
• Excellent analytical, communication and interpersonal skills.
• Performed Test and Deploy code across various SDLC Environments.
• Responsibilities also included creating architecture diagrams, data flows and data models identifying the data to migrate by developing database models
• Involved in Maintenance, Bug Fixes, Job scheduling and Code Debugging.
• Implemented Change Data Capture on databases.
• Experience with COSMOS, SCOPE and Cosmos Power Shell
• Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER
• Good knowledge of object oriented paradigms for c#.Net to maintain and find functionality in MSBI
• Excellent communication, analytical skills and strong ability to perform as part of a team
• Good understanding of healthcare domain, HIPAA regulations and continuous communication with different stakeholders, clients like Medicare, Medicaid, CHIP
• Handle daily Service Now tickets raised by internal teams and issues with customer reports deployed in Production
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures and disaster recovery.ntelligence Process for Data Integration and Migration services.
• Hands on experience in configuring and creating SSIS solutions for ETL.
• Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Experience in using Microsoft .NET framework for SQL Server Integration Services (SSIS) packagesfor logging programmatically and managing, automating Control flow, Data flow and Events.
• Experience in building Data Mart using Oracle SQL Developer to be consumed by MS Power BI reports and dashboards
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Experience in Troubleshooting Report Processing, Configuration of different problems, Subscription and Delivery.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Design, Develop and Deploy Microsoft Power BI reports
• Developed Scorecards/Reports for the system using SSRS
• Experience in creating Multidimensional Cubes using SQL Server Analysis Services (SSAS).
• Experience in implementing KPI’s, Aggregation, Partitions, Perspectives, Hierarchies and Calculated Members using SSAS.

TECHNICAL SKILLS

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS)

Reporting Tools: SSRS 2012/2008/2005 , Crystal Reports XI/X/9/8, Excel.

Database: MS SQL Server 2012/2008/2005 , Oracle 10g/9i/8i, MYSQL, MS-ACCESS.

Programming: C, C++, Visual C++ 6.0, VB6.0, C#.Net, VB.Net, PL/SQL, TSQL,Java EE

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

Operating System: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

Web Technologies: HTML, XML, JavaScript, PHP, Shell Scripting, jQuery.

PROFESSIONAL EXPERIENCE

Confidential, Bloomfield, CT

Sr. SQL BI Developer

Responsibilities:

• Actively involved in gathering System Specification Requirements for the projects
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated to update the database statistics.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• As part of Data Subsetting-Agile Data Solutions, developed the Data Subsetting process where in customer avail the quality data on-demand across the lower environments to perform efficient testing
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Worked on the Hadoop solution to perform Data Masking for the Hadoop applications using Hive and Sqoop by implementing the logic in Python
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Created views as required by front end developer for easier implementation and wrote triggers on theassociatedtables to provide efficient data manipulation.
• Tested, Cleaned and Standardized Data toassociate the business standards using Fuzzy /exact lookups using SSIS tasks.
• As part of Data Subsetting solution for Hadoop applications, analyzed the applications which are different from the existing Data Subsetting solution for Oracle and SQL Server
• Using SQL Server Reporting Services (SSRS) generated periodic reports based on the statistical analysis of the data
• Developed Power BI reports and dashboards from multiple data sources using data bending
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis Server (SSAS)
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio
• Designed Power BI data virtualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts
• Exported data in a variety of ways and across multiple visualization using Power BI.
• As part of Data Mining activity, provided the data for different test scenarios to PVS and QA testing teams
• Involved in developing backup/recovery strategies.
• Developed macros to produce the Data Profiling statistical graphs.
• Experience in creating multiple reports (SSRS) in Drill down mode using tables, financial tables, crosses tabs and charts
• Participated in the application development process and code reviews of database objects.
• Documented MS SQL Server database design, implementation and configuration.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Agile, T-SQL, SQL Profiler, GIT, SQL Developer 4.0.1, Power BI.

Confidential

Sr. SQL BI Developer

Responsibilities:

• Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Handle the tasks of providing technical leadership and guidance to team members
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions
• Worked on Deployment of packages into Production servers and managed scheduled SQL jobs
• Create Cosmos scripts which pulls data from upstream structured streams and include business logic & transformations to meet the requirements
• Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Troubleshoot the failed cosmos job and fix the issues in timely manner
• Involved in creating complicated packages with custom coding using c#.net in SSIS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2014 as well as Created interface stored procedures used in SSIS to load/transform data to the database
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Develop the scripts which push the data from the cosmos output streams into SQL Server Databases
• Lead team to validate agile change requests, revise plan bi-weekly and get client approval
• Developed generic ETL packages in SSIS for the User Maintained files which are loaded to Oracle data warehouse using file sources
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Created custom C# and VB Scripts to loop through set of files and extract the data based on the column information
• Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.

Environment: MS SQL Server 2014/2012/2008 R2, MS SQL,SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Agile, C#.NET, T-SQL, SQL Profiler, XML,DB2, Subversion (SVN), MS Excel, SQL Developer 4.0.1, Power BI.

Confidential, Eden Prairie, MN

SQL BI Developer

Responsibilities:

• Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on a daily basis.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Create and manage Reports subscriptions and schedules SSRS reports
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Created SSIS packages to Extract, Transformation and Load (ETL) inventory and other sales data from Flat Files, Excel Files, Access, Mainframe DB2, Oracle etc.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for debug, performance checks and performed index tuning and query optimization
• Created database maintenance planner for the performance of SQL Server, which covers database integrity checks and re-indexing
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area

Environment: MS SQL Server 2012/2008R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Agile, MS SQL Server Analysis Services (SSAS), C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), SQL Developer.