SUMMARY:

• Around 12+ years of progressive experience as Lead Developer/Architect on Data Transformation, Data Warehousing, Data Analytics and Data Visualization mostly on MSBI data platform. Overall experience includes understanding business processes, requirement gathering, analysis, design, development, testing, implementation and technical support.
• Experience with SQL Server 2000, 2005, 2008, 2012, 2014 and proficient in T - SQL queries, Stored Procedure,
• Dynamic SQL, Indexes, Joins, Views, Table variables, User & System defined functions, Triggers, Cursors, CTE, Nested Queries, Performance Tuning etc.
• Hands-on expertise in MS SQL Server 2008/2012/2014 suite of products like SSIS, SSRS and SSAS.
• Developed SSIS packages using SSIS Designer for exporting/importing heterogeneous data from sources like MS access, Oracle, Excel, SQL server, flat file, XML, etc. and migration from .
• Proficient in various SSIS data transformation task such as Lookup, Fuzzy Lookup, Aggregate Functions, Merge Join, Conditional Split, Data Conversion, Derived Column, Event Handlers & Error Handlers etc.
• Proficient in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS packages using SQL server agent.
• Developed Python scripts for data extraction, transformation, validation and data loading.
• Expert in creating various types of complex reports using MSBI SSRS (SQL server reporting services) such as Drill-Down, Parameterized, Cascading, Conditional, Matrix, Ad-hoc, Sub-Reports, and Charts.
• Installed and configured SQL server Reporting Services (SSRS) in scale-out deployment model, designed and deployed reports on the portal using web interface and report manger.
• Experience in configuring SSRS Report Manager, Report server, Send emails to end user and Scheduling reports.
• Excellent experience in MS SQL Server database and MSBI ETL capabilities using SQL Server Business Intelligence Studio (BIDS), SQL Server Data Tools (SQDT) and SQL Server Management Studio (SSMS).
• Involved in developing Data models, Data dictionaries, mapping documents and cross-functional documents across systems for all the ETL needs and knowledge in Database Administration.
• Used tools like MS SQL Profiler, Index Tuning Wizard for monitoring and tuning SQL Server performance
• Experience in creating visualizations using Power BI and Tableau and proficient in various chart types like, Bar, Line, Treemaps, Bubble chart, maps with geo tags.
• Proficient in DAX language for calculations and data analysis on data in PowerBI.
• Collaborated with Business Analysts, Web development team and end-users on database solutions.
• Experience in ASP.Net, VB.Net, C#, Visual Studio Team Foundation Server, Visual Studio 2005/2008/2012/2015.
• Knowledge on AWS cloud services EC2, EBS, S3, RDS, IAM, VPC, ELB, Security group, Lambda and CloudWatch.
• Proficient in OLTP, OLAP/Data Warehouse, Data Mart, OLAP cubes, Drill Down reports and Sub Reports using SSAS SQL server analysis Services. Knowledge in Excel power query, power pivot, power map.
• Proficient on Data mining models, deploying and Processing SSAS objects and understanding of Data marts, Data warehouse, Operational Data Store (ODS), OLAP, Data modeling like Dimensional data modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensional table using SSAS.
• Good experience of implementing iterative Software Development Life Cycle (SDLC) using Waterfall and Agile.
• Domain knowledge on resourcing, manufacturing and retail industries.
• Versatile team player with excellent analytical, presentation and communication skills with strong ability to facilitate easy and transparent exchange of information across the team.
• Ability and adaptability to work with different technologies and frameworks.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2000/2005/ 2008/2012/2014

T: SQL, ASP.NET, Visual Basic .NET, C#, Visual Basic 6, ASP, HTML, CSS, XML, JavaScript, VBScript

BI Tools: DTS 2000, MSBI SQL Integration Services 2005/2008/2014, MSBI SQL Reporting Services 2005/2008/2014, Tableau, Power BI, MSBI SSAS

Operating Systems: Windows NT/XP/7/10, Windows 2012/2008/2003 Server

Version control: TFS, VSS, #define, Tortoise SVN

Other Tools: Encryption tool GPG

Cloud: AWS services EC2, EBS, S3, RDS, IAM, VPC, ELB, Security group, Lambda, CloudWatch

PROFESSIONAL EXPERIENCE:

Confidential

Lead ETL Consultant

Responsibilities:

• Engaged with the project teams to understand the functional requirement
• Responsible for preparing technical specification based on functional requirement.
• Agile methodology is followed with sprint and involved in sprint planning, review and SCRUM meeting
• Lead a team of 5 members
• Designed the ETL process and data flow from different global systems to custom database
• Developed the MSBI SSIS package for the data load from XML source file using Merge join
• Used package configuration in SSIS packages to make environment independent
• Job scheduling in SQL Server for the SSIS package and used notification services to creating alerts on job execution status
• Created maintenance jobs to archive older files with configurable value to define the days for older files
• Created complex stored procedures using CTE, nested queries for the application functionality

Environment: SSIS 2014, SQL Server, TFS 2013, SharePoint 2016, Visual Studio 2015

Confidential

Lead Data Analyst

Responsibilities:

• Engaging with the project teams to understand the business support model
• Developing, documenting and publishing the data mapping for the implementations
• Mapping the ticketing tool data into the data template structure that management dashboard requires
• Created SSIS packages to load the data from different ticketing tool databases
• Utilized different types of tasks (Execute SQL task, Data flow task, For Loop Container, For each Loop Container, Bulk Insert task) to load the data from source to destination
• Developed Cubes using SQL Analysis Services (SSAS) and extended OLAP Cubes, Dimensions, and data source view
• Designing dashboard content and developing in Tableau with Quick Filters and Parameters
• Implemented data blending advanced visualizations in Tableau, worked on dual axes, Individual axis in reports
• Developed dashboard with Treemap with ticket categorization, map chart with geo tags for mapping ticketing data from different office locations
• Generated Tableau dashboards with combination charts with quick filters for clear understanding
• Created visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tables

Environment: Tableau, MSBI SSIS, SSAS, SQL Server 2008, Visual Studio 2012

Confidential

Tech Lead

Responsibilities:

• Lead technical team of 8 members by providing assistance in resolving technical issues and process work flow.
• Involved in data modeling, data mapping and data dictionary
• Created SSIS Packages, stored procedures, user defined functions and views, reviewed the code, documents
• Transformed and loaded (ETL) Oracle HRMS data from flat files, excel sources using MSBI SSIS packages
• Created packages for fixed-length, delimited output files, encrypted output file using GnuPG
• Developed and deployed MSBI SSIS packages in Production Server with deployment utility
• Performed Data Analysis and Data profiling using SQL on various sources
• Developed scripts in Python for Extracting Data from XML files
• Written Python script to validate the output data file differences with the previous data file generated
• Ensure data quality and integrity in databases by DBCC command
• Participate in service operational reviews, ensuring SLA’s are met as per client’s requirement
• Written documentation to describe interface development as part of knowledge management
• Responsible for creating and scheduling the jobs to run stored procedures and SSIS packages on daily schedule to automate the loading process using SQL Server Agent, adding new steps to the existing jobs
• Extracted the code from global #define repository with versioning history to the new repository using command line code of #define

Environment: SQL Server 2008R2, SQL Integration Services 2008, SQL Reporting Services 2008, C#, #define, Tortoise SVN, GPG, Python, Visual Studio 2008

Confidential

Tech Lead/Web Developer

Responsibilities:

• Lead technical team of 10 members by providing assistance in resolving technical issues
• Requirement gathering from UK and NL clients
• Responsible for preparing technical specification, test case creation, release scheduling, code review and training the onsite and offshore team members for the support
• Designing and building database objects, creating SSIS packages for ETL
• Used Power BI for interactive visualizations and Data Analysis purposes
• Developed Web Parts to have the basic information of the member in corporate SharePoint page
• Developed and deployed web pages along with SSIS packages to organization’s private cloud servers
• Involved in Query Optimization, Performance Tuning using SQL Profiler, Index rebuilding
• Developed customized error logging to log error in file system while displaying a friendly message to user
• SSRS design, installation, configuration in scale-out topology, development of SSRS reports.
• Worked on SSRS with Report authoring, Report management, Report delivery and Report security
• Developed SQL Server Parameterized Reports with .Net embedded code
• Migrated SQL Server, SSIS, SSRS from SQL and later

Environment: ASP.Net, VB.Net, XML, XSLT, SQL Server 2005/2008, SSIS 2005/2008, SSRS 2005/2008, PowerBI, VSS, Visual Studio 2005

Confidential

Lead Web Developer

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications, designing, developing, Integration testing, Unit testing to Go live production support
• Member in Database designing, written Stored Procedures, Views and developed ASP web pages
• Written unit test cases and performed unit testing; Peer-reviewed the code

Environment: ASP, SQL Server 2000, HTML, Java Script, IIS 6.0