SUMMARY

• Around 8 years of experience in analyzing, designing, and developing Client/Server,Data Warehousing/ Data Modeling /Business Intelligence (BI)Stackdatabase applications using MS SQL Server 2016/14/12/08/05 , SQL Server Integration, and Reporting & Analysis Services.(SSIS, SSRS & SSAS),Azure Data Factory, Data Lake Store, Data Lake Analytics.
• Extensive Experience in database administration, design, development and business intelligence of cosmos Microsoft SQL Server 2016/2012/2008 R 2/2005/2000.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Strong Knowledge on creating SSIS packages using control flow tasks like Execute SQL Task, FTP, For Loop, For - each-Loop, Execute Package task, etc. and data flow tasks like Derived column, Slowly Changing Dimension, Look up, Conditional Split, OLEDB command, etc.
• Highly Experienced in SQL Server performance tuning, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC and DMV’S. In-depth noledge of T-SQL, SQL (DDL, DML, and DCL).
• Expert in creating SQL Queries, PL/SQL package, Functions, Stored Procedures, Triggers, Cursors, materialized views and customized views .
• Extensive experience wif different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• Had experience in data modeling using Erwin,Star SchemaModeling, andSnowflakemodeling, FACT and Dimensions tables, physical and logical modeling.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Extensively used Report Wizard, Report Builder and Report Manager for developing and deploying reports in SSRS.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports using SSRS.
• Strong experience in MS SQL Server wif SQL Server Integration Services (SSIS)and SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’S, OLAP charts and SSRS Reports wif PPS.
• Expertise in Team Foundation Server (TFS) 2012/2010 & 2008 Administration Included Project Administration, Users, Groups, Permissions and Trigger, Data Tier.
• Good Knowledge onMicrostrategyreports, Development of Metrics, Attributes, Filters and various other Micro strategy components.
• Experience in handling Master Data Management (MDM) services and setting up teh Master Data Services (MDS) to integrate and maintain various entities.
• Strong background in a disciplined software development life cycle (SDLC) process and TEMPhas excellent analytical, programming and problem solving skills.

TECHNICAL SKILLS

Languages: SQL, T- SQL, HTML, Oracle 9i/10g/11g, MySql, data warehouse, XML, PL/SQL, DB2

Databases: SQL Server 2014/2012/2008/2005/2000/7.0 , MS Access

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

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data

Data Modeling Tools: Erwin, Visio

Testing: Unit Testing, Performance Testing, Integration Testing, Stress Testing

Other Software: MS Office- 2013/2010/2007/2003

Operating Systems: Windows 2003/XP/Vista/8.0/8.1/10

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

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, CA

Sr. MSBI/SSIS/SSRS Developer

Responsibilities:

• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Interacting wif Business Analysts and Developers in identifying teh requirements, designing and implementing teh Database Schema.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Expertise in constructing T-SQLand Oracle PL/SQLTables, Stored Procedures, Views, Functions, Packages, Triggers, Cursors, Indexes, User Defined Data Types, Constraints to facilitate efficient data manipulations as per teh business rule.
• Created MDX queries to retrieve data from teh cube and to display SSRS reports.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Interacted wif various Businesses, Management and IT units and analyzed business & functional requirements.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
• Involved in gathering, understanding and validating teh project specifications.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries also trimming lengthy queries by replacing sub queries wif JOINS to enhance teh performance of Databases.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Created and managed Database(s) on SQL AZURE. Setting up Connection Strings and connecting SQL Server Azure Databases from locally Installed SQL Server Management Studio.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked in Agile Environment and used JIRA for project management.
• Participated in teh meetings between Business Users and Technical team to gather and discuss teh business requirements and convert them into technical/functional requirements.
• Scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.

Environment: SQL Server 2016/2014/2012 , Visual Studio2017, 2015,2013, Framework 4.5, C#.Net, XML, Entity Framework, Microsoft Office, Excel, Word, Windows server 2010, Business intelligence development studio, Tableau 10.4, SQL profiler, MS Visio-SQL, Azure,DTS, Data Analyzer.

Confidential, Lexington, KY

Sr. MSBI/SSIS/SSRS Developer

Responsibilities:

• Created SSIS package to check XML file validation and data validation to match teh requirements.
• Was involved in teh Design of Data Modeling and Implementation of database design.
• Created SSIS Packages to load data from sources like Excel (.xls, .xlsx), Flat Files, .csv files.
• Performed fine tuning of stored procedures and SSIS packages.
• Created complex Stored Procedures, Tables, Views, SQL Joins and other statements to maintained referential integrity and implemented complex business login.
• Strong noledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards.
• Extensively used DAX functions like SUM, MIN, AVG, COUNTROWS, DISTINCTCOUNT, SWITCH, CALCULATE, CALULATETABLE, ALL, VALUES, SUMMARIZE, ADD COLUMNS, ROW in Power BI and Tabular reports.
• Created and managed database objects such as tables, views, indexes, stored procedures, user defined functions. Maintained user permissions, referential integrity, SQL agent jobs.
• Created Ad-hoc reports wif complex T-SQLqueries based on business requirement.
• Wrote complex T-SQL queries and stored procedures for teh building reports in SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports.
• Worked on to develop Report Structure wif data definition, report layout and report definition language.
• Created various Complex Formula Reports to query teh database for business Intelligence.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports wif drop down menu option, sorting teh data, defining subtotals and handling parameterized reports and creating report layouts using SSRS.
• Developed different kind of reports such a sub reports, charts, matrix reports, linked reports. Creating SQL agent jobs after successful development of ETL packages and SQL codes.
• Experienced in creating nested Grouping, sortingcolumns and writing expressions per teh business requirements.
• Distributed reports via SSRS in different formats to users on a weekly, monthly basis.

Environment: Microsoft SQL Server 2016/2014/2012 , SQL Server Integration Services(SSIS), Visual Studio, BIDS, SQL Data tools, Oracle SQL Developer, Power BI, Erwin, Service Now, MS Team Foundation Server(TFS)

Confidential, Pleasanton, CA

MSBI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to teh database and written functions, stored procedures and triggers.
• Worked wif Product Development Team to architect Database Design and strategy.
• Directly involved into requirement gathering and understanding business functions wif teh end users.
• Generated SSRS Reports using Stored Procedures, direct SQL, MDX, DAX Scripts for teh various Drill-through reports, parameterized reports and linked reports using SSRS.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Understanding theOLAPprocessing for changing and maintaining teh data warehouse.
• Designed and optimized dynamic SQL batches to perform bulk operations in teh OLTP environment.
• Designed and developed efficient SSIS packages for processing fact and dimension tables.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Monitored performance wif SQL Profiler and Windows System Monitor.
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, Web Services) and loaded teh data into target data sources by performing various kinds of transformations using SQL Server Integration Services (SSIS).
• Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance.
• Modified T-SQL Stored Procedure, Triggers for validating teh integrity.
• Implemented slowly changing dimension transformation to maintain teh historical data in data warehouse.
• Created packages wif different control flow options and data flow transformations such as Conditional Split, Derived Column, Look up, Data Conversion, Merge, Merge Join.
• Created TEMPeffective User Defined Function, Stored Procedure, Triggers, Transactions to facilitate data consistency and efficient data manipulation.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.

Environment: MS SQL Server 2008/2010/2012 , SQL Server Integration Services (SSIS) 2010, SQL Server Reporting Services (SSRS) 2010, SQL Profiler, Database Engine Tuning Advisor, Tableau 7.0, MS Office, Windows 7.

Confidential

SQL Developer

Responsibilities:

• Gatheird requirements and created requirement specification documents for all reports.
• Developed documentation to reflect current design ETL processes.
• Database Design, Optimization of queries and Database, Performance Tuning using Index Wizard, SQL Profiler and Query Analyzer. Installed SQL Server Desktop Database and Standard Database.
• Created Stored Procedures, User Defined Functions, and Triggers to work consistently wif teh dynamic databases.
• Investigating and fixing teh root cause of teh problems that are encountered on in production environments on day to day basis.
• Involved in SQL Tuning by creation of Indexes, Rebuilding Indexes, and Clusters
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, and XML etc.) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services (SSRS).
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned teh complete Back-up of various Databases for Disaster recovery scenarios.
• Developed backup and recovery plans based on OLTP load and server down time.
• Created T-SQL queries used in PIVOT/UPIVOT, CTE.
• Created Linked Servers and send data across multiple Servers.
• Created Functions and Stored Procedures and Views.
• Provided 24/7 production support for teh production database and also to teh code deployed into teh production environment.
• Involved in analyzing business requirements and design documents.
• Involved in interacting wif business people on daily basis for better understanding and implementation.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS)