PROFESSIONAL SUMMARY:

• TEMPHas an overall IT experience of 10+ years working on SQL Server 2000/2005/2008/2008 R2/2012, which includes T - SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS), .net applications, Performance Point services, SharePoint 2010
• Microsoft certified, SQL server Technology Specialist (MCTS 70-431), on Designing database, Implementation and maintenance of Database. TEMPHas good noledge on Data warehousing concepts.
• Expert in implementing a Microsoft BI SQL Server project end to end in all modules following teh SDLC. Good exposure on Data Modeling and Data analysis.
• Expert in Designing and creating SSAS Cubes & writing SSAS MDX, designing and implementing data warehouses and data marts using components of Kimball Methodology, like ConformedFacts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc
• Expert in developing SSIS Packages with most of teh data feeds. Working on varied Transformations
• Expert in writing reports in SSRS
• Excellent SQL Server Developer skills including writing stored procedures, views, functions, tables, indexes and complex T-SQL query writing.
• Had proven ability in designing Dashboards in Performance Point Services, Reports, and report models in SSRS 2005/2008.
• Expert in creating Tableau Workbooks, Dashboards with Visualizations.
• Proven ability in Performance Tuning, Query Optimization
• Experience on Teradata DB, fast scripts & Macros
• Capable of handling medium to large teams.

TECHNICAL SKILLS:

Languages: SQL, T-SQL, MDX, Java (basic coding)

Databases: Microsoft SQL server 2005 and 2008 R2, 2012

Database tools: SQL Server Management Studio Enterprise Manager Query Analyzer, QL ProfilerETL SSIS, MS Access

Reporting: SSRS, Performance Point Services (PPS), Excel Power Pivot, Tableau

OLAP: SSAS, Excel

Front end: SharePoint 2010, .net

Change Management: Jira, Microsoft Team Foundation Server 2010

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Associate

Responsibilities:

• Upgrade teh database from, Do some POC before making sure everything works fine in teh larger scale
• Upgrade 175 SSIS packages from SSIS 2005 to SSIS 2012
• Upgrade teh SSAS cubes - a total of 24 cubes, 4 business critical cubes
• Upgrade 250 SSRS reports from SSRS 2005 to SSRS 2012
• We have a web portal for displaying teh SSAS Pivot reports & SSRS reports. It needs IIS configuration- had set it up from End to End
• Did production parallel for 3 weeks to proof out both teh systems, Duplicating 200 feeds.
• As teh manager TEMPhas left teh firm in teh mid of dis upgrade I had to Lead teh project both technically & from Project Management - TPM
• End to End responsibility of teh delivery
• Completed teh Project successfully in 4 months built phase and 6 months for Infrastructure Procurement
• Analyzing data quality and applying business rules in all layers of data extraction.
• Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
• Integrating data from different source system Repo system built on Sybase, ADM System and do Extraction, Transformation and Loading data (ETL) using SQL Server Integration Services (SSIS)
• Write queries on top of teh Teradata environment and created visualizations on teh Tableau for different internal groups
• Created pre aggregated business required multi-dimensional calculations in SQL Server Analysis Services cubes for Tri-party data (SSAS). Created cubes for Triparty Summary and Triparty Detail
• Work with back office and operations team to validate teh daily Net Free Equity (NFE) for teh clients on BNYM using different analysis based out of SSAS, SSIS and Excel.
• Create models and trends to display teh NFE for teh clients in Tableau
• Design Data feed for Markit from Control management Systems (MCS)
• Gathering requirements from business users and providing estimations for deliverables.
• Prepare Solution design for teh requirements
• Creates Projects tasks /Gantt charts for teh project
• Created SSIS packages for different file feeds coming into teh application from Repo Edge, ALGO, GSCX - worked on teh flat files, Excel files, DB connections, Sybase.
• Build BA1 SSIS Framework in SSIS using Master and child packages, Handling teh files landing, preprocessing of teh files, keep a stub if teh files are correct, process teh files, Zip teh files & archive once teh processing is done.
• Create Data Structures that will support teh SSIS Framework
• Implement Script Tasks with VB.net in SSIS
• Handled file delivery to teh external groups using SSIS & Winscp
• Creating Reports using teh SQL Server Reporting services (SSRS) fetching data both from tables and cubes.
• Create ad-hoc report both in SSRS and Excel as required on day-to-day activities handling requests from multiple cross functional teams.
• Implemented 2A7 process for teh top banking clients.

Confidential, NY

Sr. BI Consultant

Responsibilities:

• Gathering requirements from business users and providing estimations for deliverables.
• Analyzing data quality and applying business rules in all layers of data extraction.
• Integrating data from different source system to Risk Data store by Applying Lookups, Merge, Cache, Data conversion etc transformations for standardizing teh data using SSIS
• Created SQL Server stored procedures. TEMPHas done performance tuning by creating indexes, temporary tables, Partition functions, table variables.
• Worked with different Front Office Source systems like EUCLID, TOTORO, VIPER, and VENOM.
• Created Autosys - Jil Scripts for Job scheduling
• Covert SSAS Cubes built on SQL Server tables to Oracle tables
• Worked on Oracle Exadata
• Created Matrix and tabular reports in SSRS 2008.
• Involved in MONJU used for calculating VAR (Value at Risk) in Risk Management.
• Working on Oracle 11i.

Confidential

Technical Architect & Lead

Responsibilities:

• Architecting a MSBI solution approach for teh requirements gatheird from teh client.
• Gather business requirements. Configured teh BI setup for teh client SQLServer, PPS, SharePoint
• Analyze teh requirements.
• Propose a data model, Solution Approach
• Develop teh Technical plan, Detail design Documents, Assign work to teh team.
• Create SSIS Package templates, SSAS OLAP Cubes, SSRS reports, Performance Point services reports,
• Excel Power pivot 2010 reports, PPS dashboards deployed on SharePoint 2010
• Create a Visio representation diagram of teh Flow of data between sources.
• Created complex MDX measures required for HR talent, Staffing, Attrition dashboards.
• Code deployment to teh production.

Confidential

Tech Lead

Responsibilities:

• Designed Data-model using Erwin data modeling.
• Create conceptual, logical, and physical data models to define teh informational needs of teh DW.
• Perform physical database design to implement teh physical data model.
• Designed SSIS package template, developed a solution approach for SSAS cubes, SSRS reports
• Designed SQL SSIS 2008 Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Oracle, SAP and flat files into SQL Server 2008 for further Data Analysis and Reporting by using multiple transformations
• Created a SSAS OLAP Cube on Operational Meta data of teh project and provide SSRS reports on Load statistics using graphs and charts.
• Creation of master scripts for teh procedures, functions, views.
• Involved in designing cubes, implementing security and querying using MDX.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Develop data models for applications, metadata tables, views or related database structures.
• Designed and developed automatic alert system to monitor performance.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Also did a POC for client on migrating Access 2003 to SQL server 2008 and SharePoint 2010
• Installed and configured Visual Studio 2010 Team Foundation services for teh project

Confidential

Data Modeler/Architect/ETL Specialist

Responsibilities:

• Built SSIS packages required for teh new implementation of Grocery ROI.
• Built SSAS cubes required for teh new division and fine tuning teh existing ones for performance optimization.
• Built teh reports required for teh client using teh SSRS
• Designed a solution approach for Wine Subscriptions end to end in SQL Server.
• Preparing teh release notes for teh deployments in LIVE, OPS,INT environments
• Supporting for teh deployment happening
• Coding stored procedures, functions in T-sql
• Fixing teh technical issues popped up in teh deployment phase.
• Involved in teh work on TFS
• Handling teh INT, OPS, and LIVE deployments.
• Performance tuning of teh procedures, cubes, packages

Confidential, TX

Sr SQL Server Developer & Lead

Responsibilities:

• Creation of master scripts for teh procedures, functions, views.
• Performance tuning of procedures, views and packages
• Used visual source safe for versioning of teh project modules
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Use teh SQL Analyzer and Profiler for analyzing teh SQL statements and procedures.
• Designed Data source views, Partitioning, roles in teh development of cubes using SSAS 2005.
• Implemented aggregations, calculated measures in cubes.

Confidential, Atlanta

Sr SQL Server Developer

Responsibilities:

• Interaction with clients, business users, SME’s on technical and functional aspects
• Solution Development for change requests.
• Resolving teh issues popped at production server.
• Worked on teh multi-terabyte data warehouse.
• Sole responsible taken for migration and reorganizing teh Business units in teh project and successfully completed without any technical and functions issues.
• Analysis of teh requirement thoroughly as it required day to day operations on these business units.
• Trained in MDM solutions, Netezza DB as part of teh KO NA intiative
• Analyzed teh existing data and performed teh migration steps to SQL Server 2005.Moving teh master data in MDM and moving Meta data in Division databases.
• Worked on billions of rows of data in tables for migrating across teh databases/divisions both for master data and fact data
• Synchronizing teh databases.
• Creating and Configuring teh SSIS packages required for teh migration
• Moving teh data into SSAS cubes, creating partitions and changing teh roles.
• Creating measures, measure groups and calculated measures using MDX
• Changing teh .net code, C# code across teh divisions.
• Creating teh SSRS reports.
• Security implementation for teh new division.
• Involved in teh module to load teh data from MS Access to SQL server 2005 using teh Integration services packages
• Setting up teh Access database password used for teh SSIS package using teh admin.
• Configuring teh access connection manager using teh Jet ODBC.
• Identifying teh normal queries and parameterized queries and applying teh logic in teh package flow.
• Doing transformations on teh access data using teh SSIS transformations and loading to teh SQL Server
• Received client accolades for successful completion of CSE reorganization
• Development work on MDM.
• T-SQL Coding like procedures, functions, triggers, views.
• Worked on team foundation server enabled source safe of teh modules.

Confidential

Database Developer

Responsibilities:

• Analysis of teh specifications provided by teh clients.
• Review business requirements with business teams.
• Building OLAP Dimensions, DSV’s and Cubes using SSAS -2005.
• Building Reports using teh data from teh cube in SSRS -2005
• Develop software code for teh solution and conduct unit and system testing.
• Coding teh stored procedures required for teh reports.
• Making comparative reports on actual and expected results.
• Creating Test Reports.