PROFESSIONAL SUMMARY:

• Possess 3+ year of professional experience in Data warehouse full lifecycle developer and data analyst in various domains such as Banking, Health, Retail and Logistics
• Excellent experience on ETL Process for large scale data warehouse development ( SSIS ), developing Multi/Tabular dimensional cubes using SQL Server Analysis Services ( SSAS ), developing/rendering reports by using Reporting Services ( SSRS ) and Power - BI .
• Having Good experience in C# and Vb.net for automation of SSIS Packages and custom coding in SSRS reports.
• Having extensive experience in Software Development life-cycle (SDLC) while implementing system designing, data modeling, application development, maintenance and support by using Agile and waterfall methodologies
• Experience in designing Star schema, Snowflake Schema and Dimensional modeling .
• Having good experience on Normalization and De-Normalization techniques
• Expertise in Working with various RDBMS like Oracle, SQL Server
• E xtensive experience in development of T-SQL and PL/SQL Scripts for business logic implementation by using FSD and TSD
• Extensive experience in dealing with Relational Database Management Systems (RDBMS) while developing and implementation of CDC Changes, Stored Procedures, Functions, Joins, Indexes, Views, Data Import/Export and Triggers
• Proficiency in creating ETL framework creation to Extract, Transform and Load from numerous heterogeneous sources to destinations while applying various transformations.
• Responsible for implementation of Meta data viewers, SSIS Custom Loggings and Checkpoints, Event handlers in the packages.
• Expertise in Using Conformed, Role-Played, Junk, De generated, Parent-Child and Slowly Changing Dimensions
• Excellent experience on creating Calculated Measure and Analyzing MDX Queries
• Experience in creating Role based Security and Row level Security in cubes using SSAS.
• Expertise in developing SSAS dynamic Partitions with SSIS, and designing Aggregations.
• Expertise in developing SSRS reports while connecting through SSAS
• Good in writing MDX and DAX Queries while creating calculated measures.
• Having Extensive experience on various SSRS reports development such as Drilldown, Drill through, Sub reports, Parameterized, Cascading, Linked, URL and ad-hoc reports
• Having extensive experience on SSRS report deployments, Data driven Subscriptions and Job scheduling and maintenance.
• Gathering insightful information and requirements to develop reports such as QlikView, SSRS, and Power-BI. Made custom inquiries/reports intended for quality confirmation and data sharing.
• Having experience on SharePoint 2013 while deploying SSRS and Power-BI Reports.
• Worked on Qlikview Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications.
• Created PDF push reports and setup email distribution on QlikView Publisher.
• Reviewed QlikView error logs and provided production support.
• Performance tuning of dashboards was carried out to limit the response time to well Calculation and defining server sizing for optimal performance of QlikView dashboards.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized reporting using Qlikview11.

TECHNICAL SKILLS:

Programming Languages: SQL,T-SQL,Pl/SQL,VB.Net,C#, .Net, MDX,DAX

BI Tools: SSIS, SSAS, SSRS, Power-BI, QlikView

Web Development skills: HTML,XML

Version Controls: TFS,SVN

Defect Tracking Tools: HP ALM, JIRA

Document Management: SharePoint

MS Applications: Microsoft office, VBA Macro s

Operating Systems: MS DOS, Linux, MS-Windows

PROFESSIONAL EXPERIENCE:

Confidentil, McLean, VA

BI Engineer

Responsibilities:

• Worked on Collection of requirements and implementation of designing documentation
• Wrote Stored Procedures, Functions, Views including with Temporary tables based on TSD and FSD
• Designed and developed various SSIS packages with script component with Custom Check points, Event Handlers Custom logging's for task and package level and created XML Package Configurations
• Experience in Performance Tuning in SSIS packages by using Row, Block and Unblock Transformations.
• Developed Historical/Incremental of SSIS Packages with SCD2 concept of Star Schema
• Gathered good knowledge on Incremental load of SCD2 with the implementation of KPI’s.
• Created Packaging structures with CR’s in TFS and deployed into server boxes by using batch scripts for Quick batch deployments.
• Implemented Historical and Delta load changes as per requirements.
• Developed Pointing Time tables and Recon Time Tables.
• SSIS packages(ISPAC) Deployments and Job schedules in Sql 2012 and maintenance
• Integrated with main front end application with respective Schedules.
• Created Packaging structures with CR’s in TFS and deployed into server boxes by using batch scripts
• Implemented Parallel Processing to fetch the data loading and creating user files
• Developed History and Delta changes as per instruction files.
• Managing Zipped files through SFTP client and unzipping encrypted files.
• Extracting Updated Files and loading into staging to dimension tables.
• Updating field’s accordingly incremental loading and Historical Loading by using SHA1 algorithms.
• Created Dashboards with different style using Qlikview components like List Box, Slider, Buttons, charts and Bookmarks.
• Uses QVD and incremental loading to delete, insert and update records and highlight items changed; QV publisher to schedule jobs for different users in different departments.
• Develops KPIs and set analysis application with Qlikview functions (join, concatenate, keep, and applymap)
• Implemented Section access and Hidden scripting for the Application Security
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Responsible for Development and maintenance of Qlikview and Power-BI Reports.

Environment: SQL Server 2012/2008 R2,Oracle 10g, MS-BI(SSAS, SSIS, SSRS), MDX, C#Confidential

Associate SQL Developer

Responsibilities:

• Extracting, Transforming and Loading data from Flat files to Staging area.
• Transferring data From Staging Destination to Data warehouse using Optimized queries.
• Generating Slowly Changing Dimensions for Loading Historical, Changing and Fixed attributes.
• Developed SSIS frameworks according requirements.
• Developed Custom Loggings and (XML,SQL Server) Package Configurations and Scheduling of SQL Agent jobs while integrating with SSIS Packages .
• Developed Encryption and decryption in database for payroll files.
• Migrating SSIS packages and SSRS reports from 2005 to 2008 R2.
• Developed SSIS frame work to manage flow of structure with expressions & precedence Constraints.
• Logging Connection Strings and Connection Managers in Dynamic format.
• IN SSSIS packages passing queries through Sql command variables
• Involved in Unit Testing and Performance Tuning of for all SSIS Packages.
• Developed Pointing Time Tables and Recon Modeling.
• Created Packaging structures with CR’s in TFS and deployed into server boxes by using batch scripts
• End user files bug fixing by using various SSIS components and Sql, T-Sql
• Implemented Parallel Processing to fetch the data loading and creating user files
• Developed History and Delta changes as per instruction files.
• Developed Database in SQL Server which includes Designing Database, creating Tables in accordance with Normalization concept
• Designed and developed OLAP using MS SQL Server Analysis Services.
• Involved in converting SQL Server 2005 data using SSIS.
• Designed and developed MS SQL Server Reporting Services(SSRS) Chart, Sub reports and Parameterized reports.
• Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Sort and Execute SQL Task to load data into Database.

Environment: SSIS, SSRS, SSAS, Sql Server 2005/2008/2008 R2, C#, SVN