PROFESSIONAL SUMMARY

• 13+ years of experience as Confidential BI developer, database developer and data analyst with Confidential SQL Server 2016/ 2014/2012/2008 R2/2008/2005, SSIS/SSRS/SSAS, OLTP, OLAP (Different environment such as Production, UAT, and development) and Power BI in various domains.
• Participated actively in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, go live and Post Go Live Support.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL
• Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Optimizing long running ETL packages by using different mechanisms.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Migrated data in various formats like text files, Excel spreadsheets etc. to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experience loading 1TB of data from multiple sources converted from text fields to database data types, transferred over the network, and inserted into a single destination server involving multiple partitions
• Experience working on huge data, millions of records in a table.
• Sound knowledge of Data Marts, Operational Data Store (ODS), OLAP, dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables) using Analysis Services.
• Experience in Providing the cube level security (Data level, Column level)
• Expert in creating several types of complex reports using SSRS (SQL server reporting services) such as Drill-Down, Parameterized, Cascading, Conditional, Matrix, Ad-hoc, Sub-Reports, and Charts.
• Extensive knowledge in Administering, Managing and Troubleshooting Reporting services.
• Efficient in creating Sub-Queries and Joins for complex queries linking multiple tables and Exception Handlers.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS. Created shared dimension tables, measures, hierarchies, levels and aggregations on MS OLAP/ Analysis Server (SSAS).
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Hands-on development experience working with large volume db. Strong knowledge of table partitions, high performance loading and data processing. Practical experience to decide between DB vs. ETL processing OR both.
• Experience in using Team Foundation Server tool.
• Excellent problem solving, multitasking, business analytical and critical thinking with the ability to work on fast based environment.

TECHNICAL SKILL

Modeling Tool: MS Visio

Methodologies: SDLC Waterfall, Scrum, Agile methodology.

BI Tool: SSIS, SSAS, SSRS, Report Builder 2.0/3.0, Power BI

Database Tools: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), Team Foundation Server.

GUI /Tools: MS Word, MS Excel, MS PowerPoint.

Database & Query Tools: SQL Server 2014/2012/2008 / R2/2005, Oracle 10g, MS Access.

Operating Systems: DOS 6.22, Windows 98/95, Windows XP, UNIX, Windows 2007

Specialist: SQL Server 2008, Database Development

PROFESSIONAL EXPERIENCE

Confidential, Oaks, PA

Sr. MSBI/ Power BI Developer

Responsibilities:

• Xpressfeed is S&P Capital IQ's data warehouse management/ bulk delivery solution utilizing the strengths of S&P ratings data to deliver financial data that helps Client enhance their proprietary analytics, financial portals, CRM systems and more. Xpressfeed's turnkey database loading and maintenance technology provides reliable, efficient data delivery and management in a relational database warehouse.
• The Enterprise Solutions implementation of Xpressfeed will replace the two existing versions of Xpressfeed - the Xpressfeed app that produces the Compustat products and the XF app that produces the CIQ product. Eventually, all products created by the Compustat and CIQ XF apps will be migrated to Enterprise Solutions Xpressfeed (ES XF). ES XF is designed to take the best of the two existing implementations and build on it to create a more flexible and scalable application that will support the needs of MHF into the future.
• ES XF uses data from a variety of source databases which contain data pertaining to a large variety of content sets including Financials, estimates, Equity prices and Company ownership. So, created SSIS packages to export huge data containing over 10 million records into Sql server database which has 10 partitions including PRIMARY FILE GROUP.
• Worked on Subscribers and Publications as part of Replication scripts. Data is delivered into the XF feeds databases through replication set up on the tables containing data to delivered via XF.
• Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Optimized MOLAP Cubes by partitioning them, Designing Aggregations, implementing Hierarchies and Calculated Members. Worked on MDX queries to access Cubes.
• Extensively worked on ETL to transform data and load it into the DWH.
• Real-time replication transfers the source data tables to XF environment servers and these tables have CDC in place. So, worked on CDC as part of it.
• XF delivers this data to clients in subscribed ‘packages’. Each package typically has two forms - full and transactional delivery. So, worked on delivery packages using SSIS features.
• Utilized GoldenGate for data replication where data is originated from both Oracle and SQL Server data sources.
• Configured data partitioning/table partitioning on large tables containing millions of rows in Data ware house databases for better performance and performed Data Compression on large tables to reduce the Database size.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment in TFS 2012.
• Created complex sql scripts to implement Initial load and Incremental load of tables.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
• Worked on SSRS 2016 to build parameterized, drill- down, interactive reports and dashboards for Business users to make decisions.
• The XF metadata is used by the ES XF Engine to generate the feeds, to populate the FeedConfig file that is distributed with the data files, to create and maintain data tables etc. Worked on the implementation logic to achieve it.

Environment: SQL Server 2016, T-SQL, SSAS, TFS, SSIS, SSRS, VSTS.

Confidential, Berlin, CT

MSBI /Power BI Developer

Responsibilities:

• Publicly traded, Fortune 500 energy company headquartered in Hartford, Connecticut and Boston, Massachusetts, with several regulated subsidiaries offering retail electricity, natural gas service and water service to approximately 4 million customers in Connecticut, Massachusetts and New Hampshire.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, AggregateConditional split, SQL task, Script task and Send Mail task etc.
• Worked on development of SSIS packages for various inbound/outbound data, OLAP data architecture as well as export functionalities in SQL Server 2014.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2008/2012.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Creating Dashboard Reports using Power BI and Tableau.
• Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Experience in developing Database Schemas / Joins, Views, Indexes, Stored Procedures / Data Dictionary.
• Experience and knowledge in designing and developing data visualization strategies.
• Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Demonstrated experience in utilizing design tools, development tools, code management, regression testing and performance tuning.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Extensive Experience on Cube Development both OLAP & Tabular Cube Environments.
• Extensive Knowledge in SSAS storage Modes, partitions, Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service Generated custom and parameterized reports using SSRS
• Created Sub Reports, Snapshot, Cache and Linked Reports.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Created Dimensions with the cube wizard and individually and Generated Named calculations and named queries.
• Developed customized reports using Power BI Desktop based on the requirement.
• Created Cubes using diverse types of OLAP methods like Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP).
• Written complex T-SQL queries and created Stored Procedures, Triggers, Function and Views to get data from multiple databases.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.

Environment: MS SQL Server 2014/2012/2008 R2, SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Power BI, SQL Server Enterprise Edition, SSIS, SSRS, SSAS, MDX, Tabular Cube, Power Pivots-SQL, SQL Agent, SQL Profiler, MS Access, MS Excel, & Windows Server, C#, TFS, MS Visio.

Confidential, Oaks, PA

Sr. MSBI Developer

Responsibilities:

• The Sales comp project is using ICM application with Sql server 2014 as part of the backend database. There are some sql server processes that run as a pre-process before running jobs in ICM, this allow the processes to run faster. This application is being rolled out to the entire sales force for both US and Canada for all divisions and secondary positions. We are utilizing report features from ICM, Excel, SSRS Power BI and Cognos. Permissions are set in ICM by groups. This is one central location for all sales comp data from the mainframe and other outside sources. The ICM system allows us to pay US and Canada sales force. Account moves, structure, pay plans for payee, forecast, activity, selection criteria, account information, SCC (sales credit corrections) and performance\ pay calculations are set up in the ICM system. Some of the data is modified\ updated by sales comp admin group and the management level of the sales force.
• Designed, developed and tested various Power BI visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• As a Power BI SME responsible for the design, development and production support of interactive data visualizations used across the company.
• Migrated data between different heterogeneous sources such as flat file, Excel and SQL Server using SSIS, BCP and Bulk Insert. Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices. Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across same and various data sources.
• Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard.
• Excellent SQL skills for daily testing of data using various SQL queries.
• Created calculated columns, wrote complex measures using Data Analysis Expression Language (DAX)
• Proficient in work with large volumes of data (millions to billions of rows)
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Used Parameters and Quick filters, Dynamic X and Y axes using Parameters, Table Calculations.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using Power BI.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Optimize various SQL queries to make the reports run faster.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
• Create nested, conditional subgroups and formatting features in reports.
• Create Sub reports called from the main report to implement the business logic.
• Generate reports with parameters, sub reports, cross tabs, charts

Environment: SQL Server 2016, T-SQL, SSIS, SSRS, Power BI, VSTS, Jira

Confidential, Pittsburgh, PA

Sr. MS BI Developer

Responsibilities:

• Fund View enables you to review information and performance data on SEI Administered Funds. The Fund Reporting Team is data warehouse of Fund level information. You can get holdings and performance information as well as portfolio related information. The database is refreshed nightly with information from Fund Center and SunGard Invest One.
• Gathered end user’s requirements, Developed Logical Model, and implemented requirements using SQL server 2012/2008 R2.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Worked closely with project stakeholders and staff to understand requirement specifications new applications and redesigning existing applications.
• Prepared project Progress Report and Status Reports and submitted it to Top management on weekly basis.
• Created Data Flow Diagram (DFD) and Flow Charts to display the flow of information in the new system.
• Developed SQL scripts for administration task.
• Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Imported data from different databases (oracle, MS access etc.), build and scheduled packages, and defined integration flow using SSIS (SQL server Integration Services).
• Created ETL (Extract, Transform, and Load) packages to validate and load data in to data warehouse, database, and data marts.
• Designed and implemented parameterized, drill-through, drill-down and tabular reports using SSRS.
• Developed crossed reports, sub-reports and matrix in SSRS.
• Implementing customer scenarios in test environment providing best practices, good with Azure service model and Azure Resource Model.
• Good understanding on Azure Architectural components, Good understand and Experience on Azure Various Services.
• Created complex queries to build the dataset required for developing the SSRS reports.
• Implemented/Developed multi parameterized reports using Report Builder and SSRS allowing users to make selections before executing the reports and making it more users friendly.
• Created different 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.
• Provided 2 weeks training as a part of knowledge transfer on SSRS and SSIS to the client to modify existing and develop their own ad-hoc reports and SSIS package.
• Designed, developed and implemented database systems and Stored Procedures based on Client requirements.
• Involved in database Schema Design, development and executed stored procedures Using Batch files.
• Built integrated reporting tools (Using Confidential Power BI) with data from Sales, Marketing, and Finance systems.

Environment: SQL Server 2014/2012, T-SQL, Windows 7, SSRS, SSAS, SSIS, Jira, Power BI, Azure, MS Visio, Team Foundation Server (TFS).

Confidential, NY

DB Team Lead

Responsibilities:

• The SMA Sequel project is designed to create a rotation management tool to create automation and efficiencies in our SMA unit. In the SMA unit, their trading team manages many different sponsor programs. Some of these sponsor programs require our SMA team to deliver model updates, while others ask that we trade names directly on their behalf. The objective of this project is to create a tool that provides SMA with the technology they need to manage the sponsor notification process. Our tool will order these sponsors and allow SMA to efficiently notify sponsors of model changes.Created Data Flow diagrams and flow charts to display the flow of information in the system and make users understand the functionalities.
• Worked with design and admin team to design physical database and its modifications.
• Responsible for project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.
• Performed Data Analysis and Data profiling using SQL on various sources.
• Collaborated with fellow team members through Team Foundation Server (TFS) for effective project management, which includes work issues and track on the update of versions.
• Designed/build/deployed the SSIS package to import data from different data sources and performed ETL process before loading the data in to data warehouse using SQL server integration services (SSIS).
• Created ETL SSIS packages both design and code to process data to client databases.
• Created SSIS template for developing SSIS packages to dynamically deploy the packages into the development, Testing, and production environments.
• Worked with Team Foundation Server (TFS) to report source code for Packages in Visual Studio 2012.
• Created different formats of the reports using SSRS as per the end user and business requirements.
• Worked on Confidential Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Performed system testing for the SSIS packages and SSRS reports.
• Used Notification services to generate error messages and notify users through e-mails.
• Participate in service operational reviews, ensuring SLA’s are met as per Clients Requirement.
• Design, develop and implement database systems and store procedures based on client requirements.
• Ensure data quality and integrity in databases by DBCC command.
• Designed physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for warehouse system.

Environment: SQL Server 2012 R2, T-SQL, Windows 7, SSRS, SSIS, Team Foundation Server (TFS), Power BI, MS Visio, SharePoint, Jira, SCRUM.

Confidential, Redmond, WA

Sr SQL/BI Developer

Responsibilities:

• Sales Excellence has embarked on an initiative to compile a standard, accurate view of our Expiring EA base by which the business can make informed decisions and respond to market conditions. One key result will be to ensure that the core sales motions for managing expiries are reinforced and sustained. This comprises of two applications namely EA Tracker and True-Up Tracker.
• EA Tracker:
• The EA Tracker Bridge report exposes Adjusted EA Renewal & Recapture performance by geography for the EPG business, in direct support of the Deal Factory initiative. By incorporating field-adjustments, the EA Tracker facilitates more meaningful discussions and generates insights used to help sales leaders pinpoint areas in which to improve renewals execution. Deal Factory expectations driven through the EA Tracker consist of: 100% EA Agreement Renewal and 90% Revenue Renewal Rate.
• True-Up Tracker:
• The True-Up Tracker Bridge report exposes end-to-end guidance to Subsidiaries on how to maximize the volume of True-Ups received from customers, how to identify, prioritize and approach customers to maximize revenue associated with True-Ups.
• Documentation of developed BI solution as a part of knowledge transformation.
• Analysis of business requirement and various source systems for data and metadata information.
• Responsible for preparing technical specification based on functional requirement.
• Prepared unit test cases based on functional and technical specifications.
• Performed Data Analysis and Data profiling using SQL on various sources.
• Implemented and executed SSIS 2008 packages to import/export data from the different source to perform the ETL process.
• Used different SSIS transformations such as RecordSet destination, For Each Loop container, Multicast Transformation, Derived Column Transformation to create new column, Conditional Split Transformation to split data flow using Business Intelligence Development Studio (BIDS).
• Created SSIS package which implements Data Profiling using SSIS Expressions, Variables, Expressions and SQL Server based Package configurations
• Modified the existing SSIS packages to increase the performance of the packages.
• Experience in DAX language for calculations and data analysis on data in power pivot and Power BI.
• Used Power BI for interactive visualizations and Data Analysis purposes with SSBI capabilities.
• Created and modified the existing SSRS reports based on T-SQL using Business Intelligence Development studio (BIDS).
• Used and defined reports Parameters, created Parameter Cascading to populate sub-reports, drill down reports, and drill through reports.
• Created PerformancePoint based Dashboards having Web Parts of SSRS Report, Pie Chart, Funnel Chart, and bar charts.
• Expert in Implement, deploy and configure Azure websites, configure diagnostics, monitoring and analytics on Azure Platform along with scale and resilience for Azure Web sites.
• Reviewed, performed unit and system testing, and fixed bugs for SSIS package, and reports using SQL 2008 Business Intelligence Development studios.
• Identify improvements to the services provided, based on the SLA and KPI data collected.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Created store procedure, functions, views, index to handle database automation task.
• Developed Database structures, store procedures, DDL triggers and user defined functions to optimize the database performances.
• Experience with KPI reporting and dashboards to support decision-making and performance tracking process.

Environment: SQL Server 2014, Power BI, T-SQL, SSRS, SSAS, SSIS, Azure.

Confidential

Sr SQL Developer/Analyst

Responsibilities:

• The SMSP Corporate Territory Management (CTM) team is responsible for reporting sales by establishing consistent operational standards around the Sales, Called Forecast, Reporting Process (Tools, Roles and Responsibilities and Timing) to integrate CTM & CAM forecasts into a US EPG Forecast workbook view. This will ultimately drive accountability, accuracy and predicative capabilities for the business.
• Gathered requirements and prepared business requirement documents (BRD).
• Analysis of the requirements and providing estimation.
• Development of new process.
• Unit Testing.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels.
• Created Database Objects - Tables, Indexes, Views, User defined functions, CTEs, Cursors, Triggers, Stored Procedure and Constraints.
• Worked on Deploying Packages and providing security while deploying.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
• Tuned, monitored and maintained SQL Server Jobs.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.

Environment: SQL Server 20012, BIDS, T-SQL

Confidential

SQL Developer

Responsibilities:

• DISCO (District Industry Segment Comparison) is an easily accessible one stop shop providing current Reported Revenue and Quota information in US Hierarchy with US business rules to Field and Finance. The purpose of the DISCO system is to give North American Sales & Marketing a single point of reference to compare quota estimate to actual sales. This system brings in multiple feeds, on a nightly basis, and classifies this data based on defined hierarchies in SAMI Planning. Once processing is complete, cubes are built on an analytic server for customer consumption.
• Analysis of the requirements and providing estimation.
• Development of new process.
• Unit Testing.
• Checking the coding standards using checklists.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Tuned, monitored and maintained SQL Server Jobs.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Involved in Query Optimization, Performance Tuning and rebuilding the indexes at regular intervals for better performance.
• Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
• Worked in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Defined Calculated members, named sets and executed other script commands using MDX expressions.
• Developed many small and complex packages to perform ETL Operations.
• Worked on Deploying Packages and providing security while deploying.
• Experience in maintaining SQL Server jobs and involved in developing\maintaining SSIS packages and SSAS cubes.
• Used Dimensions, Measure Groups, Calculations, Key Performance Indicators (KPI), Partitions, Perspectives and Actions while developing SSAS Cubes.
• Supporting customer ad-hoc requests.

Environment: SQL Server 2012, BIDS, T-SQL

Confidential, NY

SQL Developer

Responsibilities:

• Patient assistance programs (PAPs) are programs created by drug companies, such as PFIZER, Merck to offer free or low-cost drugs to individuals who are unable to pay for their medication. These programs have different eligibility and application requirements based on manufacturer. The purpose of this project is to facilitate the Health centers tied up with Confidential to accommodate the Prescription Assistance Programs (PAP). It focuses on the capabilities needed by the Health Centre to employ free prescription drug programs offered by manufacturers to save on drug costs for qualifying patients. It assists in automating the process of applying for PAP programs to maximize the efficiency of the work force to manage more patients in the PAP program and ultimately reduce drug costs to Health Centers. The system includes the following features.
• Analysis of the requirements and providing estimation.
• Development of new process.
• Unit Testing.
• Checking the coding standards using checklists.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels
• Develop SQL Server Agent jobs and packages to populate data.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Created and manipulated many small and Complex packages to perform ETL operations.
• Supporting customer ad-hoc requests.

Environment: Windows Server 2008, SQL Server 2008, SSRS, SQL Server Management Studio