SUMMARY:

• 15+ years of progressively responsible experience in designing, implementation, administration and maintenance of very large and complex database of Business Intelligence, Relational Database (OLTP)/Warehouse (OLAP) (Batch Processing, Online Processing), ETL, Data warehousing, Data mining, DBMS and Data Modeling using in SQL Server using SQL Server 2016/ 2014/2012/2008 R2/2005, SSIS, SSRS and SSAS. Experience in implementation of Data Warehousing projects with Teradata using Business Intelligence (BI) environment.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation. Capable of handling responsibilities independently as well as a proactive team member. Highly involved in Agile Methodologies to produce high quality results. Ability to work with.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Hands on Experience on Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables using Erwin & MS Visio. Involved in design of the normalized level2 - CDM, LDM & PDM design.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Extensive experience working with ETL tools including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2. Well versed with SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer. Creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management. Utilized AWS stack (EC2, Route53, and Dynamo DB etc.)
• Experience in creating Tables, Views, Joins, Index views, Temp Table, Table Variable, Functions, Batch Scripts, complex Stored Procedures, UDFs Cursors, Derived tables, CTE, Indexes, efficient Triggers, new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH etc. at various stages of migration/cleansing process, reports or data validation to facilitate efficient data manipulation and data consistency using SQL/T-SQL 2016/ 2014/2012/2008 R2/2008/2005 & Postgresql.
• Experience in using DMV and Dynamic management functions for finding out long running queries. Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Used various sources to pull data into Power BI such as Sql Server, Oracle, SQL Azure etc.
• Created reports utilizing SSRS, Excel services, Tableau,Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
• Experience in monitoring SQL Server Performance in SQL Server 2016/ 2014/2012/2008 R2/2008/2005 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard and Windows Performance Monitor. Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Experience in data migration (using tools like DTS, BULK INSERT, BCP and Replication) between different homogeneous/heterogeneous systems and SQL Server.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Extensive Experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts using SQL server Analysis Services (SSAS).
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Extensive experience in building Dimensions, Measures and fact tables using SSAS. Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas.
• Thorough Knowledge of Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP), and Hybrid OLAP (HOLAP).
• Extensive experience in Basic and Advanced report creation with thorough knowledge of reporting service architecture. Experience in Report development-Standard, Canned & Dashboard, Drill-down, Drill-through OLAP/OLTP reports, Report on SSAS Cube using MDX,DAX, On demand, Ad Hoc Reports, Enterprise, Summary, Sub Reports, Power view Reports, Master/Detail report, Linked Report, Dynamic grouping, Cross-Tab, Frequency reports etc) using SQL server Reporting Services (SSRS).
• Excellent command on Subscriptions, report snapshot and report cache. Extensive experience on scheduling and the deployment of the SSRS reports and uploading files to a report server catalog from the report manger.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Thorough knowledge and extensive experience in using .NET Framework Common Language Runtime (CLR) assemblies to create SQL Server objects, such as stored procedures and triggers.
• Thorough knowledge of XML in SQL Server 2014/2012/2008 R 2/2008/2005.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Team player with excellent communication and problem solving skills, presentation skills with strong aptitude towards learning new technologies. Strong experience in mentoring team members and writing documentation.24 X 7 Production Database on Call Support

TECHNICAL SKILLS:

DATABASE/RDBMS: SQLServer 2016/ 2014/2012/2008 R2, SQL AZURE, POSTGRESQL, Oracle 10/9i/8.0, DB2,MS Access

Database Technologies/Tools: SQL Management Studio,SQL Business Intelligence Studio (SSIS/SSRS/SSAS)

Visual Studio: POSTGRESQL, SQL Enterprise Manager, SQL Analyzer, SQL Profiler, SharePoint Server

ETL: SQL Server Integration Services SSIS

ETL Tools: Business Object ETL

OLAP/Reporting: SQL Server Analysis Services Cubes(SSAS) SQL Server Reporting Services(SSRS)

POWER BI: TABLEAU

SharePoint designer: EXCEL BI Tools: PowerPivot,PowerView,PowerMap Crystal Reports

Data Modeling Tool: MS VISIO, ERWIN,UML

Languages: C, C++, C#, JAVA, T-SQL,PL/SQL, Java Script,VB Script,Xml,Visual basic, ASP.NET, VB.NET, ADO.NET, Web Services

Business Objects: Crystal Report 8.5/9,Universe,Data Integrator Designer

Operating Systems: Windows 10/XP/Server 2008/2003/2000/ NT4/98/95, Linux

Utilities: BCP, OSQL, SQLCMD, DTS Import/Export, FTP

Version Control: TFS,GIT

PROFESSIONAL EXPERIENCE:

Confidential, Basking Ridge, NJ

SR. SQL SERVER Lead /BI(SSIS,SSAS,SSRS) Lead

Responsibilities:

• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Involved in analyzing business requirements and understanding the functional workflow of information from source systems to destination systems. Gather requirements and design of FACompliance/PowerTax/Property TAX/GRTVZW data warehouse and data mart entities. Involved in BRDS, FRDs, Use Cases, Activity Diagrams and Test Cases.
• Worked with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements and finalized the requirements.
• Successfully managed Extraction, Transformation and Loading SSIS (ETL) process by pulling large volume of data (Teradata) .Expert in writing T-SQL, working with DTS ( Data transformation services) data cleansing, data scrubbing and data migration.
• Established automated validation process for SSIS ETL packages developed in SSIS, which run both daily and nightly; Involved in enhancing packages and troubleshooting packages when errors occur (daily and nightly)
• Created Complex SSIS ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Automated SSIS Execution using Windows Scheduler & SQL Agent job. Created logging, custom logging and error handling packages. Grouping, aggregating, and splitting data using SSIS.Scripting using SSIS for data cleansing, encrypting, decrypting sensitive information.
• Created several Dynamic and Complex Stored Procedure, triggers, UDFs, Indexes, Views, CTE, Joins, Sequence, Event Handler (Try/Catch) using SQL 2016 T-SQL programming to implement the business logic and performance. Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in tuning performance of SSIS ETL applications to manage high volume batch data transfer to and from internal and external system locations
• Involved in data warehouse/data mart SSIS ETL/SSRS implementations teamed with project scope,analysis,requirement gathering, data modeling, effort estimates,ETL design,development,system testing, implementation and production support.
• Worked on SSIS Business Intelligence Life cycle such as SSIS packages Configurations (XML Configuration, SQL Server, and Environment variable, Parent Package Variable) to populate FACompliance Data.
• Worked on TARS/GRTVZW/PowerTAX/PropertyTax ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance.
• Worked with the data analysis team to assess and troubleshoot potential data quality issues at key intake points.
• Performed problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production
• Performed tuning of the SSISETL process and SQL queries, and recommend and implement ETL and query tuning techniques. Involved in troubleshoot data issues and defects to determine root cause.
• Formulated and documented the physical ETL process design based on business requirements and System specifications with strong SSIS ETL design skills, including source to target mappingstransformations, lookups, aggregations, expressions.
• Designed new SSRS/Tableau/Power BI reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard.
• Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.
• Excellent Knowledge in analyzing Data warehouse (DW) by building cubes using SQL Server Analysis Services (SSAS). Worked on BI Tabular model. Solid Knowledge in developing cubes using Partitions, KPI's, and Perspectives, slow changing dimensions (SCD) etc. and created various user roles (SSAS).
• Developed complex reports using multiple data providers, aggregate formula, charts, and synchronized queries. Worked on scheduling and the deployment of the SSRS reports and uploading files to a report server catalog from the report manger. Scheduling the SSRS reports to run on daily/weekly/monthly basis both automated and Manual using (SSRS) and email the results to the users in the required format. Created standard report subscription and Data Driven report Subscriptions.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column, Data conversions, Merge, OLEDB Command, script task components
• Hands on experience in writing SSIS script/script component task using C#,VB script for customized data manipulation of complex SSIS packages.Used TFS & GIT for version control and code deployment.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split and Derived column etc.
• Created various dimensions, Fact tables using SSAS by understanding business requirement, managed SSIS data loads to Data marts on daily basis (delta loads )

Environment: T-SQL 2016 programming, MSBI 2016 SSIS-ETL/SSRS/SSAS/Business Intelligence Tool/ MS Visio/Erwin, SQL Profiler 2016 Tool, Visual Studio 2015/2012, Team Foundation System 2012/2010(TFS), JIRA

Confidential, Princeton, NJ

SR. SQL SERVER /PostgreSQL/ BI(SSIS,SSAS,SSRS) Lead

Responsibilities:

• Designed and implement database logical and physical database models to design OLTP system using Erwin/MS Visio to generate students score report. Worked as a Subject Matter Expert (SME) and provide technical leadership for all data initiatives.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Involved in analyzing business requirements and understanding the functional workflow of information from source systems to destination systems. Gather requirements and design of data warehouse and data mart entities. Involved in BRDS, FRDs, Use Cases, Activity Diagrams and Test Cases.
• Created several POSTGRES/TSQL Dynamic and Complex Stored Procedures, triggers, UDFs, Indexes, Views, CTE, Joins, Sequence, Event Handler (Try/Catch) using SQL 2016/2014/2012 T-SQL programming to implement the business logic and performance for ESKM,Client Extract,ReportingLoad, TOMS assessment data,CSR,Aggregate,SIRS,TELPAS,PEIMs/PAC process.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Involved in writing Postgresql script & develop SSIS packages to calculate & fetch information
• Design and deploy rich Graphic visualization with Drill down and parameters using Tableau
• Used Postgresql/T-SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands to optimize Query and Performance Tuning. Tuned the T-SQL queries using the execution plans and avoiding unnecessary joins and other important aspects. Analyzing execution plans and creating proper Indexes using T-SQL Profiler and Database Tuning Advisor.
• Fixed deadlock and timeout issues. Involved in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Rebuilding / monitoring the indexes at regular intervals for better performance. Worked on Unix Shell Script to daily load of data.
• Involved in SSIS ETL Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server 2016/2014 Integration services (SSIS).Worked on migrating Teradata jobs to SQL Server using SSIS and worked on Incremental Loads and Delta loads.
• Used ETL multiple transformations in SSIS to meet the business requirements by collecting large volume of data from various sources (Excel, CSV, FlatFile, Oracle, XML, and PostgreSQL). Used SSIS various types of Control Flow tools and Data Flow tools like Container, Aggregate, Derived column and Conditional Splitting according to need of Data scrubbing. Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups. Worked on SQL 2016/2014 SSIS parameter to setup dynamic configuration. Created Script tasks and components with C# and VB.NET in SSIS as part of ETL load.
• Experience in providing Logging, Error handling by using Event Handler, Transactions and Checkpoints and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. Monitored and Optimized SSIS package performance to reach the expected timeframe for data loading.
• Constructed SQL server Analysis Services 2016/2014 (SSAS) Data Warehouse and designed Fact tables and Dimension tables that were populated via SSIS package from production OLTP databases. Created multi-dimensional OLAP cubes, MDX, DAX, Hierarchies, KPIs, and Attributes maintain and optimize cubes in SQL server Analysis services (SSAS) 2016/2014.
• Created Workspace and content packs for business users to view the developed Power BI reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Involved in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes. Worked on calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Involved in writing MDX query/expressions to create name sets and calculated members. Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS). Involved in Tabular Data warehouse and DAX operations for SSAS 2012
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports. Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Used various sources to pull data into Power BI such as Sql Server, Oracle, SQL Azure etc.. .
• Used Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets into SQL tables.
• Created Drill down, Tabular, Summary, Matrix, Sub Report, List, Chart, Gauge Tablix, Drilldown Cascade repot, Canned Report, Multivalve and Cascade parametric and Dashboard Reports/ Performance point based dashboard Reports using SQL server 2016/2014 Reporting Services (SSRS) . Developed Power BI Reports (against data models in Excel workbooks and against Analysis Services tabular models using SQL 2012 Reporting Services (SSRS). Embedded reports into web pages using ASP.NET Report Viewer Web Control.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel etc. Worked on Power BI application development, including visualization, parameters and report optimization.
• Attended AWS training and involved in utilizing AWS stack (EC2, Route53, Dynamo DB, auto scaling etc.
• Worked on development/staging/production environments and 2015/2012/2010 visual studio TFS for version controls. Configured SSRS reports onto Microsoft Office SharePoint Server. Worked on version control and code deployment through GIT process. Extensively worked on Jira to log and triage all requested tasks.
• Experience in using custom DLLs and VB.NET code for SSRS Localization. Extensive Excellent command on subscriptions, report snapshot and report cache. Added expression, dynamic grouping, and dynamic column selection as per SSRS report requirement.

Environment: T-SQL 2016/2014/2012 programming,PostgreSQL,POWER BI,MSBI 2016/2014/2012 (SSIS,SSAS,SSRS) Tableau, GIT,MS-Access,MS Visio/Erwin, SQL Profiler 2016/ 2014/2012/2008 R2 Tool, Visual Studio 2015/2012/2010, Team Foundation System 2012/2010(TFS), JIRA, Oracle 10, SharePoint Server, Unix Shell Script,NET Framework, C#.

Confidential, Princeton, NJ

SR SQL Server Developer /BI(SSIS,SSAS,SSRS) Lead

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems. Gather requirements and design of data warehouse and data mart entities.
• Took part in planning and estimation work for each agile sprint, actively involved in discussing technical solutions. Actively participate in sprint retrospectives and takes any actions forward for continual improvement on the team’s ability to deliver. Directed and guided teams.
• Designed and implement database conceptual/logical/physical data model using Erwin/MS Visio according to requirement.
• Train and manage US India team, advising other groups in organization on SSIS development, data warehouse development, and ETL & Report design & development best practices. Provided 24 x 7 dedicated supports to Production, QA & Development MS SQL Server
• Created several Dynamic and Complex Stored Procedure, triggers, UDFs, Indexes, Views, CTE, Joins, Sequence, Event Handler (Try/Catch) using SQL 2014/2012/2008 rR2 T-SQL programming to implement the business logic and performance. Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
• Worked on Hierarchy ID column type for Lead sheet - MLA (Multi Level Account) to show Parent Child level tree hierarchies and for DFS (Depth First Search) & BFS (Breadth First Search)
• Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands to optimize Query and Performance Tuning. Tuned the SQL queries using the execution plans and avoiding unnecessary joins and other important aspects. Fixed deadlock and timeout issues. Involved in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. Rebuilding / monitoring the indexes at regular intervals for better performance.
• Worked on all types of transformations that are available in Power BI query editor. Created stored procedures and SQL queries to pull data into Power BI power pivot model.
• Design and deploy rich Graphic visualization with Drill down and parameters using Tableau.
• Utilized Tableau server to publish and share the reports with business users
• Developed Tableau data visualization using Cross tabs, charts, Geographic Map etc.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data (Teradata) from various data sources such as Oracle, MS Access, MS Excel, Flat files, CSV files. Used SSIS Activex script task to call Web Services to evaluate Custom Rules. Used SSIS Notification task to send message through e-mails.
• Created SSIS Packages for testing and cleaning the standardized data by using tools in Data Flow Transformations for huge CSV. Files. Used SSIS various types of Control Flow tools and Data Flow tools like Container, Aggregate, Derived column and Conditional Splitting according to need of Data scrubbing.
• Used multiple transformations in SSIS to meet the business requirements by collecting large volume of data from various sources (Excel, CSV, FlatFile, and Oracle). Used SSIS various types of Control Flow tools and Data Flow tools like Container, Aggregate, Derived column and Conditional Splitting according to need of Data scrubbing. Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups. Created script tasks and components with C# and VB.NET in SSIS as part of ETL load.
• Creating SSIS Packages and involved in Package configurations and Package/Project deployments between Development and QA and Production servers.
• Constructed SQL server Analysis Services 2014/2012/2008 R2 (SSAS) Data Warehouse and designed Fact tables and Dimension tables that were populated via SSIS package from production OLTP databases. Created multi-dimensional OLAP cubes, Hierarchies, Attributes maintain and optimize cubes in SQL server Analysis services (SSAS) 2014/2012/2008 R2.
• Used (SSAS) Star Schema, Snowflake Schema, and Aggregation as per Project requirement. Defined Relationships between Dimensions and Measure Groups like Reference Relationship, Many-to-Many Relationship, and Dimension Granularity within a Measure Group.
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS). Solid Knowledge in developing cubes using Partitions, KPI's, and Perspectives, slow changing dimensions (SCD) etc. and created various user roles (SSAS).
• Created Role-playing Dimensions, Standard Dimensions, Linked dimensions, Time dimensions, and semi additive measures in (SSAS) as per client requirements.
• Involved in writing MDX query/expressions to create name sets and calculated members. Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS). Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008R2 OLAP databases.
• Created Drill down, Tabular, Summary, Matrix, Sub Report, List, Chart, Gauge Tablix, Drilldown Cascade repot, Canned Report, Multivalued and Cascade parametric and Dashboard Reports using SQL server 2014/2012/2008 R2 Reporting Services (SSRS). . Developed Power View reports against data models in Excel workbooks and against Analysis Services tabular models using SQL 2012 SSRS.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports. Worked on migration from Crystal Reports to SSRS reports.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Developed complex SSRS reports using multiple data providers, aggregate formula, charts, and synchronized queries. Worked on scheduling and the deployment of the SSRS reports and uploading files to a report server catalog from the report manger. Scheduling the SSRS reports to run on daily/weekly/monthly basis both automated and Manual using (SSRS) and email the results to the users in the required format. Created standard report subscription and Data Driven report Subscriptions.
• Worked on development/staging/production environments and 2015/2012 visual studio TFS for version controls.

Environment: T-SQL 2014/2012, POWER BI,MSBI 2014/2012 (SSIS,SSAS,SSRS), Tableau, MS-Access,MS Visio/Erwin, SQL Profiler 2014/2012/2008 R2 Tool, Visual Studio 2015/2012/2010, Team Foundation System 2012/2010,Power BI, Oracle 9i, SharePoint Server, NET Framework, C#.

Confidential, Secaucus, NJ

SR SQL Server Developer/BI Developer

Responsibilities:

• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server 2005 Integration services (SSIS).
• Designed logical and physical data models for GNE and PW system using MS Visio.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from Access, excel.
• Design and develop ETL processes to load data from multiple source system (XML, SQL Server, and flat files) into the DW (SQL Server).
• Created DTSX package to generate current Date based XML File for Account, Agreement, and Event Application. Used Xml task, Xml Source, Execute Sql task, Script task of Sql server 2005 Integration Services (SSIS) to achieve this task. Used ON ERROR functionality of SSIS to handle failed task.
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Wrote SSIS packages and configured SQL server mail agent for sending automatic mails when DTS process is success or fails.
• Extracted, cleaned and validated data from XML file into database using XML source. Managed the Metadata associated with the ETL processes used to populate the Data Warehouse using SSIS packages.
• Used Execute process task of (SSIS) to send and received files from FTP server.Used Dataflow task to transfer data from XML to XSL file.Used File System Task to Copy, Move, Rename Blueprint Project Files and Directory. Used Email Notification Task to send Status of Package execution. Used XmlStudio 2009 to validate XSD Schema with XML file.
• Used Package Configuration (.dtsconfig) to change property for dtsx package at run time for different environment (Development, QA, UAT).
• Used various transformation like Lookup, Merge join,Union All,Fuzzy Lookup, Derived Columns, Condition Split,MultiTask, Aggregate along with Control flow task like Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created reports using SSRS designer from OLTP and OLAP data sources and deployed on report server
• Created Drill down, Multi parameterized & Multivalue, tabular, Sub Report, List, Chart, drilldown cascade repot and dashboards reports according to business requirement using SQL server reporting services (SSRS).
• Developed complex SSRS reports using multiple data providers, aggregate formula, charts, and synchronized queries.Analyze system, gathered requirements from system and generate Report Mockups for Reporting.
• Worked on scheduling and the deployment of the SSRS reports and uploading files to a report server catalog from the report manger
• Scheduling the SSRS reports to run on daily/weekly/monthly basis both automated and Manual using (SSRS) and email the results to the users in the required format.
• Created Sub reports for Event and Activity for Lilli and Genetic Project; Created matrix, table report as per client requirements; used filter data with parameters; and conditional formatting using SSRS.
• Created standard report subscription and Data Driven report Subscriptions. Created SSRS Reports for Full year financial Billing details and Revenue Details.
• Worked on configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Add custom DLLs and vb.net code for Localization in SSRS Reports.Used Dynamic Script in SSRS to show Columns as per run time selection .
• Design fact and dimension tables, populated fact and dimension tables, created multi-dimensional OLAP cubes, Hierarchies, Attributes maintain and optimize cubes in SQL server 2005 Analysis services (SSAS). Used MDX queries to extract data from the cubes for the complex calculation.
• Used (SSAS) Star Schema, Snowflake Schema, Aggregation, Partition, and KPI as per Project requirement.
• Created several Dynamic and Complex Stored Procedure, trigger, Cursors, User defined functions, Inline Functions (UDF), View using Sql 2008/2005 T-SQL programming to implement the business logic and performance. Used Open XML, For XML, and XML Paths in some of the Stored Procedures.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs.Worked on SQL Profiler, Tuning Adviser (DTA), and Performance Monitor with various objects & counters, DBCC commands to record and enhance the performance.
• Worked on development/staging/production environments and visual source safe for version controls.
• Provided 24 x 7 dedicated supports to Production, QA & Development MS SQL Server Environments to resolve any issues
• Supports testing, debugging, and refining the Business Intelligence solutions to produce the required product Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production. Provide on-call support to production system.

Environment: SQL Server 2005 Enterprise Edition, Sql 2005 Integration Services,, SQL server 2005 business intelligence suite, SQL Server 2008/2005 Reporting Services, SQL Server 2005 Analysis Services, SQL Server 2008/2005 Management Studio, MS Visio,.Net Script,C#,SQL Profiler Tool

Confidential, Montvale, NJ

SR SQL Server Developer/BI Developer

Responsibilities:

• Converted the data mart from Logical design to Physical design, Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources MS Access, excel. Used SSIS Activex script task to call Web Services to evaluate Custom Rules.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting.
• Designed SQL Database objects in .NET with SQL CLR programming. Created various Stored Procedures, Functions, Triggers, and User Define Data Types using C#.
• Created SSIS Packages for testing and cleaning the Standardized Data by using tools in Data Flow Transformations for huge CSV. files.
• Created SSIS package by using advanced tools (Derived Columns, Condition Split, Aggregation, and Multicasting).
• Designed SSAS Fact and Dimension Tables, Populated Fact and Dimension Tables, Created Multi-Dimensional OLAP Cubes with KPIs, Actions
• Created Role-playing Dimensions, Standard Dimensions, Linked dimensions, Time dimensions, Additive & semi additive measures in (SSAS) as per client requirements.
• Used MOLAP storage for fastest query performance. Used multiple partitions to break up measure group into separate physical components to improve Query performance.
• Used MDX queries to extract data from the cubes for the complex calculation. Create MDX script for representing Cube Calculation.
• Responsible for creating the complex client reports and custom reports (On demand, AdHoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc) using Sql server 2005 Reporting services (SSRS).
• Created Adhoc Report Model using Report Builder, AdminReport, AuditTrailReport, MySearch Report, Matrix Report using Sql server Reporting Services 2005(SSRS)
• Generated effective SSRS reports using formulae, sections, breaks, alerter, and filters.
• Worked on scheduling and the deployment of the SSRS reports and uploading files to a SSRS report server catalog from the report manger
• Used Xml Data source to generated Configurable Component report using Sql server 2005 Reporting Services. Used XMLDiff Task of SSIS to Compare Different Version and generate Version Comparison Report using SSRS. Created standard and data driven Subscription, used report manager for securities.
• Created many complex Stored Procedures / Functions and used them in Matrix Reports.
• Create dynamic Audit Report stored procedures to display old and new values through SSRS.
• Created SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Daily/Weekly/Monthly Load as per different Time Zone. Maintain Process Log and Created Process Report using SQl server 2005 Reporting Services(SSRS)
• Worked on XML query language using XPath, XQuery as well as XSLT. Used ROW, AUTO, and EXPLISIT for defining element hierarchy in XML.Used OpenXml and ForXml for retriving data from .Net Application.
• Tuning SQL queries improving the performance of the Database. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Enhance performance in Complex stored procedures by avoiding cursors and putting Temp tables with cluster indexes and improve performance by 40%.
• Provided 24 x 7 dedicated supports to Production, QA & Development MS SQL Server Environments.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.Developed partitioned views and tables for the purpose of security and fast upload.

Environment: SQL Server 2005 Enterprise Edition, Sql server 2005 Integration services, SQL server 2005 business intelligence suite, SQL Server 2005 Reporting Services, SQL Server 2005 Analysis Services, Sql server Management Studio, MS VISIO,SQL Profiler Tool

Confidential, Columbus, GA

Sr SQL Server Developer/.NET Developer

Responsibilities:

• Effectively design, develop, and implement Business Intelligence solutions using Microsoft Integration Services 2005(SSIS), Analysis Services 2005(SSAS) and Reporting Services 2005(SSRS).
• Developed and created logical and physical database architecture using ERWIN.
• Data transfer using SSIS & DTS packages, used Open Query, Bulk Insert, BCP to copy data between various data sources Used DTS jobs for importing data from legacy systems to the current model. Used ActiveX scripting for transferred data modifications.
• Used SSIS various types of Control Flow tools and Data Flow tools like Container, Aggregate, Derived column and Conditional Splitting according to need of Data scrubbing.
• Created complex ETL Strategies to populate the Data warehouse/Data-mart facts and dimensions.Responsible for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, Fact,Measures,MDX queries, and KPI’s
• Creating SSAS OLAP CUBES and having partition on cubes on monthly bases, Pulled over those data in Excel pivot functionality sheet as per client requirement.
• Created reports by extracting data from OLAP Cube. Created report model on SSAS cubes Generated reports using SQl server reporting Services 2005 from OLAP and OLTP data source.
• Created User Conditions and Filters to improve report generation and readability of report and displayed the summary of data by creating Charts.
• Designed and deployed SSRS reports with Drill Down, Drill Through, Ad-hoc and Parameterized and Linked reports using ROLAP source. Involved in the scheduling and the deployment of the reports and assisted in uploading files to a report server catalog from the report manger.
• Created user defines functions in SSRS using VB Script. Created on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services 2005
• Work on future initiatives to add data mining/data analysis capabilities to OLAP/Reporting functions.
• Created SQL Indexes, Stored Procedures,Functions,Views and Triggers as per the requirements and needs during the project.Worked on SQL Profiler, Tuning Adviser (DTA), Systems Performance Monitoring with various objects & Counters, DBCC commands to record and enhance the performance

Environment: SQL Server 2005 Enterprise Edition, SQL server 2005 business intelligence suite,, Sql server Management Studio, ERWIN, Business Object XI,Cognos PowerPlay Transformer, Cognos Report Tool, ERWIN, Asp.Net, C#, Query Analyzer, Windows Application Log and SQL Server Event Viewer

Confidential, Parsippany, NJ

SQL Server Developer

Responsibilities:

• Build ETL processes using MS DTSX package. Used Sql 2005 DTS jobs for importing data from legacy systems to the current model. Used ActiveX scripting for transferred data modifications.
• Created (SSIS) DTSX packages to import and export data from Excel, Text File, CVS Files.
• Developed and created logical and physical database architecture using ERWIN.
• Responsible for creating the Tabular Report, Summary Reports, Sub Reports, and Drill-down, dynamic grouping, Cross-Tab etc) using SQl server reporting services 2005(SSRS).
• Created tabular, matrix, chart, drilldown reports, and parametric, cascaded reports and dashboards reports according to business requirement.
• Constructed Sql server Analysis Services 2005(SSAS) Data Warehouse and designed Fact tables and Dimension tables, OLAP cubes that were populated via DTS from production OLTP databases.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created views and stored procedures for Reports using complex SQL, T-SQL and Dynamic T-SQL. Implemented ER Integrity using Foreign Keys and Cascade Triggers.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Participated in User Acceptance Testing (UAT) for different modules. Helped creating Test Cases and Test Plans

Confidential

Software Engineer

• Hands on experience in ActiveX, COM and DCOM Technologies
• Created COM/DCOM components using VB6 (ActiveX DLL) and are Exported, Packaged and Deployed.
• Database Programming using ADO, DAO and ODBC
• Extracted, transformed, cleansed, and loaded (ETL) data from their legacy Access system to SQL Server.
• Developed stored procedures, functions and triggers in T-SQL to implement data extract, transformation, and load (ETL) processes for all raw data and to manipulate raw data into views and materialized views for reporting purposes