SUMMARY

• Over 3 years of experience in SQL server database, ETL tools, Reporting tools and hands on experience in Data warehouse design and administration.
• Strong experience in MySQL, MS SQL Server 2005/2008 with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services of 2005 and SQL Server Integration Services.
• Expert in open source ETL Tool Pentaho Kettle. Created numerous Transformations and Jobs for various functionality using almost all the available components.
• Very good experience in Linux environment and writing shell scripts.
• Strong database programming experience using SQL, PL/SQL, in constructing tables, views, Stored Procedures, indexes, relational database models and ETL techniques.
• Have provided production support, and expert in troubleshooting and fixing the problem in a short time.
• Adept at developing and supporting analysis solutions, data transformations, and reports.
• Expert in creating SQL server Reports using SSRS 2005/2008
• Experience in using global variables, expressions and system functions for the reports.
• Expert in handling parameterized reports in SSRS 2005.
• Experience in creating SQL server Analysis Projects using MS SQL Server 2005.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (Integration services) with MS SQL Server 2000/2005.
• Proficient in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Very good experience in constructing Data model, designing schemas and generating the DDL using ErWin.
• Experienced in Creating Databases based on Functional Requirements and System Design.
• Hands on experience with performing various SSIS data transformation tasks like Look - ups, Fuzzy Look-ups, Conditional Splits and Event handlers, Error Handlers etc.
• Experience in conversion of packages from legacy systems (DTS SSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Expert in creating Stored Procedure/TSQL coding, Performance and tuning
• Experience in Performance Tuning, Query Optimization and running Database checking the physical and logical consistency of a database using DBCC Utilities.
• Expert in running and scheduling the jobs in Windows and Linux environments and debugging the problem.
• Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries.
• Expert in maintaining database backups and restoring them across different environments.
• Migration from SQL Server 2000 database to SQL Server 2005 version.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Maintain positive communications and working relationships at all business levels.
• Team player and self-starter with ability to work independently or as a part of team and capable of picking up new skills quickly.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS, SSAS

RDBMS: MS SQL Server 2000/2005/2008 , MS Access, MySQL

Data Modeling: Erwin, Visio

ETL: DTS, SSIS, SQL Loader, Data Stage, Pentaho Kettle

BI Suite: SSAS, SSRS, MOSS, PPS

Programming Languages: T-SQL, PL SQL, VB Scripts, C.

Application Development: HTML, XML, CSS, .NET

IT Processes: Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. System Analyst

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for ETL development.
• Provided guidance and decision-making on client reporting needs oversee and participate in the development of the systems technical designs as well as participate in the implementation of system and testing activities.
• Constructed data models, designed schemas, generated DDL and worked with project managers on the implementation of Financial Analysis, trouble tickets and Work Orders systems for DIR and Texas Health Department.
• Created Jobs to take CSV files that we receive on daily basis from the client as input and load in the database after performing the necessary look up and transformations.
• Have deployed and scheduled the jobs on Linux servers.
• Created shell scripts to run the jobs.
• Hands on experience in rendering reports for online viewing, document management and for data exchange as excel, CSV file and XML file.
• Designed, Built, and Maintained reports, dashboards, and supporting objects in a business intelligence environment.
• Have created and scheduled batch scripts on the client’s server to extract data on daily basis to the SFTP server.
• Developed and deployed SSIS packages to extract the data from the client’s server.
• Assisted team with data validation, statistical analysis, data migration.
• Daily support, troubleshooting, monitoring all live systems.
• Worked as a team in deploying and testing the application.
• Performed unit testing and support user acceptance testing.
• Create new tables, views, indexes and procedures.
• Create joins and sub-queries for complex queries involving multiple tables.
• Created technical designs and user documentation.
• Managed the day-to-day activities to ensure the completion of deliverables on time by providing a weekly status report on progress made.
• Expert in maintaining database backups and restoring them in different environments.
• Worked with management to develop annual goals and training plans.
• Developed and maintain process controls and procedures.
• Worked in coordination with QA Team in deploying and testing the application.
• Assure full client satisfaction by 24 X 7 production support and Issue Management as per SLAs.

Environment: MySQL, SQL Server 2005, SSIS, Pentaho Data Integration Kettle, Linux, Windows Server, ErWin, Filezilla

Confidential, NJ

Sr. SQL / BI Developer

Responsibilities:

• Continuously interacted with end user to gather business requirements.
• Generated different types of Reports like Tabular, Matrix and Charts.
• Created stored procedures and user-defined functions for different Reports.
• Deployed and configured the reports in the Report Server.
• Created Subscription of Reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis.
• Created complex correlated sub queries to generate reports.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Generated reports by passing parameters through URL Developed reports using SQL Server Reporting Services.
• Performed data mapping the report columns with the database tables and columns. Documenting the data mapping and relationships between tables.
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Maintained report security by creating Service Accounts and Security Groups and configuring in the Report Server.
• Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
• Developed backup restore scripts for SQL Server as needed

Environment: MS SQL Server 2005, MS SQL Reporting Services 2005, T-SQL, SSIS 2005, Visual SourceSafe, Win 2003 Advanced Server.

Confidential

SQL developer

Responsibilities:

• Created Tables and established relationship between them using Constraints.
• Designed databases using normalize method.
• Developed and delivered optimized, complex and complicated stored procedure, triggers and also helped other developers on creating more effective stored procedures.
• Involved in database maintenance like differential and log backup / restore, checking / rectifying bad index on tables (using DBCC), etc on large database.
• Created clustered and non-clustered indexes based on the table usages and size of the table.
• Created table partitioning (Vertical and horizontal) to improve process speed.
• Involved in Developing VIEWS, TRIGGERS.
• Created clustered, non-clustered and unique indexes for better query performance
• Created and used user-defined and system functions in T-SQL for better performance.
• Designed and developed Supporting database tables and indexes.
• Developed complex stored procedures.
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Maintain, support and make enhancements to the application.

Environment: SQL Server 2005 Enterprise, Windows Enterprise Server 2003, IIS 6.0, VB.NET, .NET, MS Office.