SUMMARY

• Around 7 years of Information Technology experience in all phases of Software development life cycle including Database administration, Data Analysis and Business Intelligence.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T - SQL.
• Extensively worked with clients to understand business requirements, recommended technical solutions and documented functional requirements.
• Involved in Data Warehousing Concepts and Data Modeling Techniques like Dazur imensional Data Modeling, Star Schema Modeling, Data Vault Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Experience in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology and Agile methodology.
• Strong experience in design and developing ETL using SQL Server Integration Services (SSIS).
• Wo rked on Azure Data Factory and Azure Databricks as part of EDS transformation
• Experience in creating SSIS package to load data from Flat Files to SQL Server using various types of transformations like Lookup, Fuzzy Lookup, Multicast, Derived Columns, Condition Split, Term Extraction, Aggregate, for transferred data modifications and dataflow tasks, script tasks, for loop container, for each loop, sequence container and Slowly Changing Dimension.
• Experience in Installing, Managing, Monitoring and Troubleshooting SQL Server.
• Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS) generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS.
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key, Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Developed advance complexed scalable ETL SSIS solutions utilizing Microsoft Azure Service Bus, Web Services (Rest and Web API), and Microsoft Stream Insight Server Platform
• Expertise in generating reports on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services, Crystal Reports, MS Excel, Power BI and Tableau.
• Configure database replication from on premises to Azure SQL, data sync and migration of database to and from Premise/Azure DB.
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Test and Debug Programs on Python
• Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, Excel, CSV, MS access and flat files.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Experience with logical and physical data modeling, Fact and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Very good Self-motivated, smart working Professional with good organizational leadership.
• Implement functionality of existing systems
• Coordinate with internal Teams in Python to Understand user requirements and provide technical solutions
• Ability to work in-groups as well as independently with minimal supervision.
• Good team player, strong interpersonal, analytical and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Databases: MySQL, MS SQL Server (2008.2008R,2012,2014, 2016), Oracle (10g,11g,12c), MS Access, IBM DB2, Mongo DB

Languages: SQL, T-SQL, PL/SQL, R, SAS, Python, UML, Java, HTML, CSS

Tools: SQL Server Management Studio (SSMS), MS Visual Studio (2013/2015/2017 ), Eclipse, SQL Server Profiler, Power BI (Desktop, Server, Mobile), MS Excel, MS Word, MS Project, MS Visio 2016, SQL Plus, Tableau (Desktop, Server).

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) Import Export Data, Alteryx

Methodologies: Waterfall, Agile, Business Analysis, Object-Oriented (Use Case) Analysis, Database Design and Normalization, Data Modeling.

Machine Learning: ANOVA, Regression (Linear, Logistic, Polynomial, Decision Tree, Random Forest, Support Vector), Naïve Bayes, K-NN, Clustering (Hierarchical, K-Means)

Big Data Technologies: Hadoop, Pig, Hive, Oozie, Flume, Impala, Avro, Kafka, Spark

Operating Systems: Windows Server 2003R2/2008R2/2012, Windows (XP,7,10), Unix.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL/Power BI developer

Responsibilities:

• Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Developing SQL database and BI solutions using T-SQL, SSIS, SSRS, SSAS, MDX, query performance tunings, database development, implementation, support of data, and underlying data models.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Design and development of Datawarehouse to accommodate upcoming update or incremental data sets.
• MS Reporting Services to develop reports against an Oracle and Teradata backend.
• Experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations, scheduled the SQL jobs and SSIS Packages using Job Controller (Enterprise Scheduler) and used exceptional Handling and log in SSIS to handle errors and track the package execution.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008R2/2012 and in adding calculations using MDX.
• Designed SSIS packages to import data from multiple sources to control upstream and downstream of data into SQL Azure database and used Microsoft Azure date storage, Azure Data Factory and Data Lake.
• Wrote SQL queries on data staging tables and data warehouse tables to validate the data results.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Created Claims and Enrolment OLAP Cubes for various measure groups and dimensions for analysis of Per Member/Per Month cost to meet the business answers for the client needs using SSAS.
• Developed Tableau and Microsoft Power BI Dashboards to showcase the result of data analysis from the database
• Deployed and uploaded SSRS reports to SharePoint Server for the end users to look at them.
• Experience in creating DAX expressions, create date to yearly columns and implement partitions in tabular model for Power BI, publishing reports of dashboard in Power BI server, scheduling the dataset to refresh for upcoming data in Power BI server and understood underlying Data and reworked Data Analysis with Power BI.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS, developed and maintained enterprise reporting (SSRS Reporting Service) based on specifications and business needs and modified existing reports as needed.

Environment: MS SQL Server 2014/2012/2008 , Visual Studio 2010/2012, Tableau, Reporting Services (SSRS), Power BI, Integration Services (SSIS), Analysis Services (SSAS), T-SQL, Microsoft Azure, Excel.

Confidential, San Ramon, CA

SQL/Power BI developer

Responsibilities:

• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development .
• Gathered the functional requirements from the client.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• 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.
• Used various SSIS tasks such as Conditional Split, Derived Column, Lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes using dimensional modeling standards in SQL server.
• Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Simultaneously maintained the existing ETL and recreated new SSIS packages and created test cases for testing the SSIS packages.
• Wrote complex SQL queries and stored procedure to create reports using SSRS from the relational database.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Created SSRS Data Model projects using Microsoft Visual Studio and using Report Builder for report server to create reports.
• Developed and maintained system documentation, diagrams and flowcharts.

Environment: SQL Server 2008R2/2012, SSIS, SSRS, SSAS, T-SQL, MS Office (Word, Power point, Excel), ETL, Microsoft Visual Studio, Power BI, TFS, ERWIN, SharePoint .

Confidential, Jersey city, NJ

SQL/BI Developer

Responsibilities:

• Created stored procedures and user defines functions to support efficient data storage and manipulation, handling database objects with Enterprise Manager and provided Technical Documentation for future enhancements.
• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Developed data access queries/programs using SQL Query to run in production on a regular basis.
• Created Triggers, Cursors, Tables, Views, Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Identified various data sources, formulated data dictionaries, design and develop data models (Physical/ logical data models) based on the given specs and requirements.
• Scheduled and maintained packages by daily, weekly and monthly basis using SQL Server Agent in SSMS and involved in 24*7 production support.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Experience in end-user reporting definition, development and platform support using SQL Server Reporting Services (SSRS) and Performance Point.
• Performed ad hoc queries, design and deployed reports using SSRS and resolved any issues related with it.
• Extensively used Report Builder and Report Manager in SSRS .
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Performed tune to optimize SQL queries using SQL profiler and responsible for performance tuning of the database.
• Schedule meetings and coordinate between team members for the progress of the projects

Environment: s: T-SQL, SQL Server 2005/2008/2008 R2/2012/2014, MSBI BI Suite (SSIS, SSRS), MS Power point, MS Project, MS Visio