SUMMARY

• Over 8+ years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server 2008/2005/2000 . Experience in various industries includes Financial Services, Manufacturing, Insurance, Retail, Mortgage, pharmaceutical and banking.
• Expert in writing T - SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Extensive experience in Microsoft stack of BI solutions - SSRS, SSAS, SSIS with MS SQL 2008/2005
• Created User Defined functions to simplify code with in stored procedures as well as utilized data sources in complex ETL packages.
• Used DML triggers as well as DDL triggers as constraints Complex queries, stored procedures, views and functions Backup and Recovery procedures according to business standards
• Experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2008/2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Expertise in building and migration of various DTS packages.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008.
• Scheduled reports for Daily/Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services(SSRS)
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Experience in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Expertise in designing Database Models using UML, MS Visio and Erwin for ER modeling.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000
• MS SQL Server Reporting Service 2008/2005
• MS SQL Server Analysis Services 2008/2005
• MS SQL Server Integration Services 2008/2005
• DTS
• MS Visio 2003
• MS Access
• FrontPage
• Visual Basic 6.0
• ERWIN
• Windows 9x/NT/2000/XP/Server 2003
• T-SQL
• HTML
• XML
• Cognos Report
• VBScript
• Data Model-logical/physical ado.Net Entity Framework
• Share Point
• MSAS
• MDX Script
• Oracle and DB2 Sources
• Crystal Report
• MSAS.

PROFESSIONAL EXPERIENCE

Confidential, Erie, PA

SQL /SSRS/SSAS/SSIS Developer

Responsibilities:

• Created reports from prototype Analysis Services Cube using SQL Server 2008 Reporting Services.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Deployed and configured reports in SharePoint Server.
• Created standard & Data driven report subscriptions. Created report snapshots and cache for better performance.
• Creating Logical, Physical data model using SQL server, Erwin, MS Visio.
• Involved in code reviews meetings and designing sessions and get mentored from the tech leads.
• Strong experience in Database design and multi-dimensional modeling (star schema and snowflake schema), data cleansing, scrubbing and integration.
• Identification of facts, measures, dimensions and hierarchies for OLAP models.
• Development & deployment of OLAP Cubes using MSAS.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status, MIS reporting & MDX Scripting experience with SSRS
• Kimball Data ware house by ETL tool extract Data modeling in Star schema also work on full life-cycle BI implementation
• Configured report builder and trained business users so that they could create reports from the report models I created.
• Prepared the Layouts by placing the fields to the appropriate place of the final Report.
• Developed ETL, using SQL Server 2008 Integration Services to migrate data from Oracle data source into a SQL Server 2008 database and Creating complex SSIS packages, DTS Packages.

Environment: MS SQL Server 2008, T-SQL, SSIS packages, DTS Packages, VSS, SSRS, MS Excel, Visio, Erwin, SQL Server Analysis Services, Windows 2003 server

Confidential

SQL /SSRS/SSAS/SSIS Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and Statements for applications.
• Worked with project lead and business users to understand business processes.
• Created Views to reduce complexity of business user.
• Created Cluster and Non Cluster Index to optimize performance of TSQL queries.
• Modified/wrote a CLR stored procedure to handle the very complex business logic and for performance improvement.
• Migrated data from heterogeneous data Sources (Oracle, SQL Server, Excel, CSV file) to centralized SQL Server databases using SQL Server Integration Services.
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop )
• Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package task etc. to load underlying data in to the tables from Excel file and CSV file.
• Created an ETL/SSIS package and scheduled it on daily basis to load the fact and dimension tables.
• Designed and implemented Data Marts, facts, dimensions and OLAP cubes having star schemas using dimensional modeling principles in SSAS.
• 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.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008
• Generated Sub-Reports, Drill down reports, Tabular Report and list reports using SSRS and published as PDF, Excel formats.
• Managed, monitored the system utilization by using the query optimizer, checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Established a sound backup and recovery policies and procedures.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services, MS SQL Server Integration Services, Server Analysis Services, Excel. Kimball Data ware house.

Confidential, Irving, TX

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
• Work with other teams and team members in Verizon to resolve issues related to data. Interact with clients to understand requirements. Maintain proper documentation of the various process and code.
• Extracted data from various source systems like TeraData, Sql Server and flat files as per the requirements.
• Updated and remediate existing Business Intelligence scripts and Teradata applications to reflect changing business data requirements.
• Performed database health checks and tuned the databases using Teradata Manager.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2008 R2 and develop and unit test SSIS load processes for performance check.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Designed SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.

Environment: Windows XP, MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, Server Analysis Services, Excel, Acrobat Reader.

Confidential, NY

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created complex ETL strategies to extract, clean and deliver data to OLAP environment.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Cross Tab reports.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users, Documented and maintained history of changes for future reference.
• Involved in Data mapping, logical data modeling, created ER diagrams and used SQL queries to filter data within the database.
• Actively involved as part of a team for gathering and analyzing the needs of end User Requirement and System Specification.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Configured SQL mail agent for sending automatic emails SQL Clustering a plus and networking concepts when a SSIS process failed succeeded or completed.

Environment: Windows Server 2003, MS SQL Server 2005,Business Intelligence Development Studio (SSAS, SSRS & SSIS), TFS, MS Office Access 2003, Excel, Erwin4.0 and Visio.

Confidential, Washington D.C.

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Successfully installed and configured MS SQL Server 2005.
• Developed complex SQL queries using various Joins and Sub-queries, Views, Functions and Triggers.
• Created customized stored procedures and triggers for automating tasks.
• Created roles to bound security limited to specific tasks and assigned users to these roles.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Actively participated in user acceptance testing and troubleshooting various production issues
• Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.
• Responsible for gathering requirements and designing data mart entities and data warehouse
• Resolved issues and provided on-call support regarding production system
• Worked with system supporters, developers and DBAs in automating and evaluating
• Responsible for implementing best practices to ensure optimal performance optimized various SQL Server statements with the help of MS SQL Server Profiler.
• Performed Full Back up, recovery and restoration on MS SQL Server 2005.
• Created many complex stored procedures/functions/triggers and used them in crystal reports directly to generate reports on the fly.
• Monitor and SQL profiler and tuned queries and procedures to boost database performance.
• Used SQL profiler to optimize remote procedures and queries by creating workload files and setting various filters and parameters like cash hit ratios.

Environment: SQL Server 2000, VSS, VB Script, DTS, MS Access 2003/2000, Visual Studio 2003

Confidential

MS SQL Server Developer

Responsibilities:

• Created and maintained various databases for production, development and testing using SQL Server
• Created packages, procedures, functions, and triggers.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Imported data from text files and excel sheets into SQL Server database using DTS package.
• Created reports from database onto excel spread sheet using DTS.
• Handled database performance tunings.
• Performed everyday backup and developed recovery procedures.
• Worked on Migration techniques across different databases and servers.
• Creation of new database, planning-location of data, index and transaction log files on the disks.
• Created Users and Roles, and managed security and permission of database.
• Involved in managing Jobs and error logs.
• Involved in analyzing SQL Server Storage Structure, Index and Security Architecture
• Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Environment: SQL Server 2000, T-SQL, Query Analyzer, Outlook, DTS, BCP, Enterprise Manager.