SUMMARY

• Over 8 Years of extensive experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL Developer with expertise in SQL Server Integration, Analysis and Reporting Services
• Experienced in extracting, transforming and loading the data using SSIS in SQL Server 2005/2008/R2 and Data Transformation Services in SQL Server 2000
• Expert in data migration from OLEDB/EXCEL/FLAT fileto SQL Server 2000/2005/2008/ R2 and other destinations using SSIS
• Migrated data using SSIS, DTS wizard (Data Transformation Services) tool through data flow tasks, look up transformations and script tasks
• Developed database objects such as tables, views, stored procedures, triggers, row - level audit tables, cursors, indexes, user-defined data-types, functions, constraints
• Diagnosed performance tuning, query optimization, client/server connectivity, and running database consistency checks using DBCC Utilities
• Extensively worked on DDL/DML techniques, joins, sub queries, passing variables, looping, dynamic SQL, managing indexes and deadlocks (troubleshooting)
• Experience in performance tuning in SSIS, error and event handling, precedence constraints, break points, transactions, check points, and logging using SSIS
• Proficient in data migration between homogeneous/heterogeneous systems and SQL Server using DTS import/export utility, integration service (SSIS), BULK INSERT and BCP
• Proficient in OLTP, OLAP and data warehouse design concepts(Kimball, Inmon), experienced in relational, multi-dimensional (Star) and snowflake, logical and physical data modeling, data mapping
• Experienced in MS Analysis Services (SSAS) programming for data warehouses (Schemas), proficiency in data warehousing techniques for data cleaning, slowly changing dimension phenomenon
• Proficient in processing OLAP cube, creating KPIs, dimension usage, calculated members, perspectives, hierarchies
• Performance tuning in cube by creating storage modes (MOLAP,ROLAP,HOLAP), aggregations, usage based optimization, besides providing security by providing perspectives
• Extensive experience in reporting tabular forms, matrix (cross tab report) form, conditional, list items, charts and sub reports
• Strong technical development experience in designing and building end user reports and built OLAP cube for analysis using Cognos Web-based user interfaces (Cognos Connection, Query Studio, Report Studio, Analysis Studio) and Windows-based interfaces (Framework Manager, Transformer)
• Deploy reports, secure access, and schedule execution of reports and deliver them to the Web using reporting manager, share Point, email recipients, file shares, and more, on a scheduled basis
• High expertise in creating reports using crystal reports and SSRS (ad-hoc, drill-down, drill-through, cross-tab, sub-reports, pivot, tabular and parameterized reports)
• Experience in error and event handling, precedence constraints, break point, check points and logging
• Strong Experience on framework manager modeling (Namespaces, Joins, Loops, and Dimensions) and creating packages and deploying onto server
• Developed prompt pages and cascaded input prompts to display only the selected entries in report studio
• Defined relationships and cardinality between different tables in framework manager
• Worked on administration tasks such as backup & recovery, upgrades, creating databases/file groups/files/transaction logs
• Performance tuning of SQL Queries using execution plan index scan, index seek, bookmark lookup
• Experience in database architecture, design, coding, implementation and production support
• Knowledge of SDLC Life Cycle (Initiation, Analysis, System Design, Construction, Acceptance, Implementation) and Maintaining triple constraint project scope, on time, on budget for information technology projects
• Posses excellent management skills of outstanding decision making with excellent verbal and written communication skills, Supervised in preparing and assisting formal walkthroughs and presentations of system designs for business analysts, stakeholders and clients

TECHNICAL SKILLS

BI Tools: Microsoft BI (SSAS, SSRS), Cognos 8.x (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Transformer)

ETL Tools: SSIS, Informatica Power Center 7.x, Ascential Data Stage 7.5, SAP - BW

Database systems: MS-SQL Server 2000/2005/2008/ R2, Oracle 10g, DB2

Programming Languages: T-SQL, PL/SQL, .Net, HTML

Operating Systems: Windows 98/ME/2000/NT/XP/2003/7, MS DOS, Linux

Project Management/ Database Design: Microsoft Project/Office, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Boise, Idaho

SQL Server/ BI Developer

Responsibilities:

• Worked in team of Reporting Analytics & Data warehouse (RADW) - Operations Support & Data stage to SSIS migration Project
• As a L3 Operational support performing operational activities as per SLA
• By the process of Clear quest troubleshooting, enhance, debug databases and support customers
• Trouble shoot SSAS cubes, SSRS Reports, DataStage Jobs, SSIS Packages as part the L3 operations and Enhanced performance of Oracle database by tuning existing code (packages)
• Under take small projects build data marts for FAB, Sales, QA, Purchasing, and Inventory
• Create several new Type-1,2,3 (Hybrid Dimension Tables), and loaded several fact table which are used by the end user to create Materialized Views, Reports and SSAS Cubes
• Migrated 14 Datamarts from datastage to SSIS roughly 280 Jobs to SSIS packages as part of SSIS Migration Project
• Supported several cubes such as CTM (Capable to Match), SNP,DP(Demand Planning), GATP(Global Available to Promise), Global Inventory, cubes as part of the L3 Operational support
• Coordinate between project manager and off shore team on a daily biases on the project day to day activity
• Working as a onsite technical lead trouble shoot technical issues facing by the offshore members and coordinate with users
• Developed New packages that loads different Fact and Dimensions and scheduled jobs daily, weekly and monthly basis
• Migrated several DataStage jobs and scheduled SSIS packages, Cubes
• Experience using SharePoint to collaborate, manage content, and supply access to important information.
• Used many custom tools Auto ETL, DAT Manager for editing SSIS packages and configure SSIS packages as per the migration process
• Act as SME(Subject matter expertise) for FABDM, FIN COMMOM DM,SALESDM,GATP,DP data marts
• Create database schemas, objects in oracle and sql server database systems
• Created materialized views using schema objects for end users to browse data
• Migrated Cognos reports into SSRS reports
• Created SSIS packages using various transformation techniques and also created jobs that are scheduled to run Monthly basis to load the Data Warehouse.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, 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 ware house.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Migrated Data from SQL SERVER to ORACLE using DB LINK.
• Created reports from data warehouse using SSRS i.e. Parameterization, Drill Down, Drill Through, Sub Reports, Charts, Table.
• Created SharePoint list using SSIS 3rd part tools SharePoint destination as per the user requirement to populate data
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also sent email to analysts to review in Excel Sheet.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Developed SSIS packages to extract data from azure to on-premise with OLEDB and ADO.NET sources.
• Created the documentation according to the business requirement
• Worked with SAP team while performing middle tire functionalities
• T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Designed numerous DB Objects like Tables and Constraints (Primary Key, Foreign Key).
• Implemented and maintained and tables, Stored Procedures, functions, triggers, constraints, Indexes and complex T-sql queries
• Published reports using Share point.

Environment: SQL Server 2008, Windows XP, Ascential DataStage 7.5, SSIS, T-SQL, PL/SQL, SQL Developer, DAT Manager, Auto ETL, Sub Version, SAP- BW, Active Batch 8.0, Oracle 10g, Windows 7, C#, SSRS, SSAS, Microsoft Outlook, Relational Clear Quest, Cognos 8.4., Confidential Documentum (MDM), ADDM, MTDSM, SAP Logon, Share point 2010, Proclarity, SAP APO.

Confidential, Somerset, NJ

SQL Server/ BI Developer

Responsibilities:

• Migrated very complex Confidential Bank Actuate reports to SSRS 2005 and SSRS 2008 which are some not able to migrate but used many work around techniques to migrate this complicated reports
• Created many new reports according to the business user requirement with includes complicated expressions and tables with as many as 36 fields in the reports
• Perform unit testing at various levels of the Reports
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2005
• Written complex Stored procedure according to the business requirements for reporting purpose
• Designed & developed the various SSIS packages for the Weekly & Monthly Loads from business users in different locations in United States (Tampa. FL, Bridgewater. NJ, Morristown. NJ)
• Managed the ETL processes between various environments through scripts utilizinglinked servers, DTS packages and SSIS
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS)
• CreatedSub Reports, Parameterized and Drill down Reportsbased on the requirements provided
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables
• Converted Non-Unicode data from different databases into Unicode data and move the data to staging databases
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules usingT-SQL
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application
• Modified existing database to fit new business requirement by adding tables and relationships
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions
• Created Views and Indexed Views for the Performance Tuning
• Created automated T-SQL scripts to process summary database transactions that run off-hours
• Involved in creating, maintaining different SQL Server Objects such as Tables, Procedures, Functions, Views, CTE’s, Triggers etc. according to the Requirements
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the requirement
• Involved in Query optimization and tuning stored procedures for better performance
• Executed database backup task, check database integrity, rebuild indexes, update statistics task for maintenance
• Carry out creation of SDLC documentation for existing applications
• Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations
• Involved in preparing detailed Design Documents and Approach Documents

Environment: MS SQL Server 2005/2008/R2, Windows XP, UNIX, Visual Studio, IBM Lotus, IBM Same time, Borland Star Team, Compare IT, Performance Point Server, Microsoft Office, Snag IT 10, Actuate Reporting, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T-SQL, PL/SQL, MDX/DMX, MS Visio, Microsoft Project, Microsoft Outlook, Windows 2003/XP, XML, IIS, Microsoft Access

Confidential, Irving, TX

SQL Server/BI Developer

Responsibilities:

• The project is designed in two phase’s data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms
• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads last 4 days data from oracle into SQL Server database to store consistent and durable data
• ETL development of moving SSIS packages from 2005 environment on to 2008 with new transformations
• Built new SSIS Packages incrementally loading data dynamically on to SQL Server destination tables from different OLEDB, Flat File, .TXT and Excel files
• Deployed SSIS packages by creating configuration files making packages dynamic by creating variables
• Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages, extensively worked on mappings, incremental data loading, and SSIS transformations
• Created the dimensional & relational models for various databases for monitoring tools, created database, SSIS standards of development, configuration & deployment of the Packages
• Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS
• Created SQL server reports using SSRS 2005/2008 for manager, customer support and that can deliver at client’s station
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute sql flow task, data flow task to extract data from different databases and flat files
• Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts and sub reports
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance
• On the required reports, identified various data sources and established the connections using SSIS and constructed data source view
• Involved in creating cubes and dimensions for the new data warehouse using SQL server analysis services (SSAS)
• Created OLAP cubes in SQL Server Analysis Services 2005 & 2008 for company wide use. The data being compared in the cubes had never been available together in the same application previously.
• Created SSIS packages using different transformations in SSIS toolbox like aggregate, merge, merge join, pivot etc
• Used Team foundation server to check in/ checkout code into the source control (Team Build).
• Supported in creating KPI, calculation members and measure groups, and MDX queries
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart and OLAP cubes using SSAS
• Defined Relationships Between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, Dimension Granularity within a Measure Group in SSAS
• Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services
• Worked on databases providing security using locks, tuned existing proc, created new indexes for better performance
• Designed Common Table Expressions (CTEs), table variables, temp tables, which makes a reusable expression part of a query
• Deign, Plan, Development, Release through the process of Agile software development and deliver solution on time
• Experience in code optimization and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
• Used performance monitor/profiler to solve dead locks/long running queries
• Extensively used views for complex joins queries involving multiple tables from different databases
• Designed numerous triggers to keep track of the changes made in the database for log purpose
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring

Environment: MS SQL Server 2005/2008/2008 , DB2, Teradata, Microsoft Access, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T-SQL, PL/SQL, MDX/DMX, Team Foundation Server, MS Visio,Agile Scrum Methodology, Microsoft Access, Microsoft Project, Microsoft Outlook, Windows 2003/XP, XML, IIS

Confidential, Dallas, TX

SQL Server/ BI Developer

Responsibilities:

• Extracted data from different OLEDB sources, flat file, and excel destinations with major transformations loaded on the SQL Server destination tables
• Created SSIS packages to migrate data from Oracle to SQL Server 2008
• Responsible for coordinating the implementation of the application and conversion for various Confidential retail markets
• Created and scheduled SQL jobs to run SSIS packages on a daily basis using MS SQL Server Integration Services (SSIS) on incremental loading
• Performed data conversions from normalized database structure into flat files by using BCP import/export utility along with global temporary tables
• Published migrated data using SSIS, DTS wizard (Data Transformation Services) tool through data flow tasks, look up transformations and script tasks
• Used SSIS control flow tasks like loop containers, FTP, bulk insert, transfer job task and different data flow tasks like derived column, fuzzy lookup, data conversion
• Involved in creation of star schema and snowflake dimensional schema in MS analysis services (SSAS)
• Involved in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects
• Wrote MDX queries to retrieve the data from data warehouse dimensions and to perform analysis
• Developed sub reports, matrix/tabular reports using MS SQL Server Reporting Services (SSRS)
• Identified various data sources and established the connections using SSIS and constructed data source view based on the required reports
• Responsible for scheduling the subscription reports with the subscription report wizard
• Worked with various SSIS tasks including execute SQL task, for each loop container, file system tasks
• Generated reports with complex expressions to calculate, group, filter, parameterize and format the contents of a report using MS SQL Server Reporting Services (SSRS)
• Created and modified data driven subscriptions using SSRS Report Manager
• Written queries for the drill down reports and deployed the generated reports on to the server using MS SQL Server Reporting Services (SSRS)
• Responsible for setting up comprehensive backup and recovery Strategies for SQL Servers.
• Maintained databases with Database Consistency Checks (DBCC) such as rebuilding indexes and integrity checks
• Used execution plan to identify slow running queries to resolve query performance by designing proper indexes and updating statistics
• Worked on writing complex stored procedures using T-SQL as well as analyzing and debugging existing complex stored procedures
• Created complex stored procedures and functions to support efficient data storage, archiving, purging and manipulation
• Conducting root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, hardware bottlenecks or network latency
• Created analytical reports using PROCLARITY tool
• Utilized performance point server to create scorecards and dashboards to monitor business performance
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system
• Responsible for the creation and maintenance of entity relationship diagrams, meta data repository and comprehensive system documentation including everything from environment configuration information through standards policies and procedures
• Created user defined functions to encapsulate frequently and commonly used business logic
• Worked on new features of SQL 2005 such as RANK, NEWID, PIVOT, APPLY, ROW NUMBER and other row ranking functions

Environment: SQL Server 2008/2005, SSIS, SSRS, SSAS, T-SQL, UNIX, LINUX, SQL Server Profiler, Windows 2003, UNIX, Visual Studio, Performance Point Server, Proclarity, MDX

Confidential, Ohio

SQL Server/ BI /Cognos Report Developer

Responsibilities:

• Using SSIS extracted data from different OLEDB sources, flat file, and excel destinations made major transformation and loaded on the SQL Server destination tables
• Involved in data migration (Import & Export using BCP) from text to SQL Server2005
• Performed data conversions from flat files into a normalized database structure
• Migrated the DTS packages to SSIS packages
• Created SSIS packages to migrate slowly changing dimensions
• Worked on error and event handling, break point and check points
• Worked on different methods of logging in SSIS
• Deployed the SSIS packages from development server to production server
• Moved packages on the cognos framework manger and created new models and published packages on to report studio
• Used framework manager to build models, packages and publish packages on to report studio server
• Built models containing with complex security requirements from imported metadata
• Modified packages to suit the business needs and improved the performance of the reports by defining filters and adding calculations
• Developing standard reports(cross tab, chart), charts, drill through reports, master detail reports using report studio and ad hoc reports in query studio
• Created query prompts, calculations, conditions & filters, prompt pages, using report studio Created Complex reports using custom prompts and Tabular Objects
• Scheduling and distributing reports through schedule management in Cognos Connection
• Developing multi-dimensional analysis and building Power Cubes using Cognos Power play and Transformer and created the drill through reports for the cubes
• Associate with ETL team to create data marts build a data warehouse environment and provide constant updates about the necessary changes required

Environment: SQL Server 2005, SSIS, Cognos 8.x (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection), Transformer, Performance Point Server, Oracle8i, Windows NT/2000, UNIX Server, Cognos Power play, SQL, PL/SQL

Confidential, Camarillo, CA

SQL Server BI Developer

Responsibilities:

• Creating SSIS packages to gather data from various sources (mainframe, Informix, Oracle)
• Improving SSIS packages for better performance by reassigning the transformations
• Created DTS packages for loading data from desperate system to porters
• Installed, upgraded and migrated databases from Oracle to MS SQL Server 2005
• Designed ER diagrams and mapped the data into database objects
• Involved in Normalization to 3F for OLTP system and some De-Normalization for OLAP system.
• OLAP with the various applications to analyze the data for clients i.e. excel, reporting services.
• Experience in developing and extending OLAP Cubes, dimensions and data source views.
• SSAS storage and partitions, aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL
• Experienced in using Informatica 7.x for Extraction of data from multiple sources and load on to SQL Server, monitored dataflow using work flow manager
• Built reports for the analysis services using SQL Analysis services 2005 using different reporting tools
• Designed dimensions and using the MDX expressions for the various Optimizations like optimizing cube schema in SSAS
• Developed different types of tabular reports, matrix reports (cross tab or pivot) reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services
• Developed both the drill down and drill through reports
• Designed reports with grouping/sorting and parameters (including multi-value parameters) using SQL server reporting services
• Migration of data from MS Access to SQL 2005/2000 using upsizing wizards
• Involved in the analyzing and solving problems during the client application system’s installing, upgrading and running stages
• Wrote SQL scripts to insert/update and delete data in SQL database
• Converted existing PL/SQL stored procedures, triggers, functions and script to T-SQL
• Created schemas, views, stored procedures, triggers and functions for data migration
• Involved in the complete life cycle of the project, from planning stage to pushing the codes to production
• Responsible for query optimization using SQL tools such as SQL Profiler, Index tuning wizard
• Worked on client/server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server, Excel and Reporting Services tools.

Environment: MS SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS, SSAS, Windows XP, Oracle, T-SQL and ER-WIN, Windows 2000 Server, Informatica PowerCenter7.x (Repository Manager, Designer, Workflow Manager and Workflow Monitor)

Confidential

SQL Serve Developer/Business Analyst

Responsibilities:

• Used SQL Server Enterprise Manager and Query Analyzer to administer SQL Server 2000
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults
• Wrote user defined functions and stored procedures, and also defined roles and privileges to control access to database
• Created triggers to enforce data and referential integrity
• Created constraints, defaults, views and indexes
• Created Triggers to enforce data and referential integrity.
• Defined check constraints, business rules
• Hands on performance tuning, analyze and optimize SQL Server application using performance monitor
• Tuned the batch programs and online transactions to alleviate performance problems
• Wrote DDL, DML statements for processing of daily activities
• Involved in updating slowly changing dimensions strategies, and defined attribute properties in parent child dimensions
• Responsible for hiding and disabling attributes and attribute hierarchies
• Implementing the calculations to aggregate physical measures

Environment: Windows XP, SQL Server 2005/2000, MS Visual Studio 2005, MS Outlook, Visio, DTS