SUMMARY

• 5 Years of IT experience in MS SQL Server 2012/2008R2/2008/2005, Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services.
• Expert in Creating, configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL profiler Monitoring tool.
• Experience in creating jobs, alerts, SQL mail agent, and schedules for SSIS Packages in SQL Server Agent on daily/weekly/monthly basis.
• Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
• Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Drill-Through, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services SSRS and configured them using report server configuration manager and deployed the SSRS Reports on the portal for user accessibility.
• Experienced in Logical and Physical Database design and development, Normalization and Data modeling using SQL Server Enterprise manager and Database Models using Microsoft Visio.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and data Integrity, SQL joins and query Writing.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Expert in APIs and web services. Comfortable implementing great user experiences in the browser, managing scalability and concurrency on the server, designing database schemas and map-reduce jobs on the back-end, and deploying and admining servers on the dev-ops front.
• Good understanding of Repo market, outright trades.
• Involved in performing Unit Test, Regression Test, Functional Test, integration Test, Stored Procedure Performance Test, on Test server and preparing combined Developer Training document along with waterfall, Spiral and Agile methods with full SDLC Software Development Life Cycle

SKILLS

• MS-SQL Server 2012/2008/2005, Oracle, MY SQL 2007
• ETL Tools: SQL Server Integration Services 2005/ 2008
• Operating System Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.
• Reporting Tools SQL Server Reporting Services SSRS , Cognos
• Programming Languages C , C, C , VB.NET, Visual BASIC for Application VBA and ASP.NET
• Database Tools MS SQL, Oracle, DB2, MySQL, SQLite, MS Access, NoSQL, PostgreSQL, Hadoop, SQL Profiler, Query Analyzer
• Other Tools Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize, MS Visio, Jeera
• Version Control Tools Visual Source Safe 6.0, SVN, TFS

PROFFESIONAL EXPERIENCE:

Confidential

Big Data/SSIS/SSRS Developer

Responsibilities:

• Responsible for maintaining all 5 servers, 7instances 10 databases.
• Interact with Development Teams and Managers to analyze business needs. Provide software product design and develop a technical roadmap for the solution through the project lifecycle and beyond.
• Participated in gathering Business Requirement and system Specification. Participated in implementation the logical design to the physical design by creating tables
• Analyzed the existing data and performed the appropriate changes from SQL Server 2005 to SQL Server 2008 by following the Normalization standards to maintain data consistency and by performing data validation.
• Used SSIS to validate, Extract, Transform and load data to Data Warehouse and Data Mart Databases and Created packages to load data from Flat File and SQL Server 2005 to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Conditional Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis using SQL Server Agent.
• Created different type of reports which include: A Cross-tab, Conditional, Sub reports, Drill-down and Parameterized, Linked reports and deployed and scheduled Reports in Reports Manager using SSRS to generate all daily, week, monthly and quarterly Reports and rendered them to HTML, XML, PDF and Excel formats using Reporting Services SSRS .
• Monitoring performance and optimizing SQL queries for maximum efficiency.
• Performed Index analysis for tables and came up with more efficient solution to use Clustered and Non-clustered Indexes for significant performance boost.

SKILLS: Microsoft SQL Server 2008R2, SSRS, SSIS, XML, BIDS, MS Visio, Microsoft Share Point Server, T-SQL, .NET, MS Word and Excel, Visual Sourcesafe, SQL Profiler, Database Engine Tuning Advisor, Microsoft Windows Server 2003 Enterprise Edition, Oracle, Teradata

Confidential

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Proficient creating SQL report using oracle.
• Translated business needs into data analysis, business intelligence data sources and reporting solution for different types of Clients and also involved in JAD sessions to identify the flows and processes involved in the content.
• Involved in migration of various objects like, stored procedures, tables, views from Oracle to SQL Server SSMA Tool .
• Created various SQL Schema, Triggers, views, index/keys and stored procedures along with compiling them in SQL server and troubleshoot errors.
• Used complex query statements like, sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria.
• SSIS is used to run ETL project where total data size is a little over 1TB. The transformation process is going through different SSIS transformation tools. SSIS package is executing in parallel using TPC-H data generator where they will write in a single database destination and also provided production support to analyze and fix problems-errors on daily basis by modifying those packages and Stored Procedures if necessary.
• Generated Complex reports like reports using Cascading parameters, Snapshot reports Drill-down Reports, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SSRS based on Business Requirement Document and configured them using report server configuration manager and deployed in report server.
• Conducted performance tuning of complex SQL queries and stored procedures by using SQL Profiler and index tuning wizard.
• Experienced in reporting liquidity to establish funding needs, short-medium term financing: Libor, Swing, Prime, and investment opportunities.
• Built RESTful Web services, APIs, and other back end components/tools.
• Used Database Mirroring for increasing database availability.
• Created and implemented best backup and recovery strategies.

SKILLS: C , Microsoft SQL Server 2012, SSRS, SSIS, XML, BIDS, MS Visio, Microsoft Share Point Server, T-SQL, .NET, MS Word and Excel, SQL Profiler, Oracle, Teradata

Confidential

MS SQL Server/Oracle Developer/ DBA

Responsibilities:

• Worked with applications developers and productions teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server 2005 on the production server.
• Automated the migration of data from Oracle DB to MS SQL Server 2005 DB, using Microsoft SQL Server Migration Assistant SSMA .
• Converted the Oracle DB Objects to MS SQL Server 2005 DB Objects like tables, views, and stored procedures.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Created SSIS packages to load data from the OLTP system to a Data Mart for analyzing data.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.

SKILLS: Microsoft SQL Server 2005, SSAS, SSIS, Visual Studio 2005, T-SQL, MS Access, Windows XP, Erwin v4.0., SSMA, Oracle

Confidential

Data Modeler/ ETL /BI Developer

Responsibilities:

• Planned, Defined and designed data based on business requirement and provided documentation.
• Involved in making Use Case and Process Flow Diagram for Business Requirement Document using MS Visio.
• Worked with 170 SQL Server instances including 2000, 2005, 2008 versions supporting about 30 databases. The largest server was about 1100 gigs and largest database is about 25 Gigs.
• Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
• Created Dynamics SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.
• Involved in creating alerts for successful or unsuccessful completion of schedule jobs.
• Designed, Development and Deployed parameterized reports, sub reports, tabular reports in MS SQL Server environment using SSRS 2008 and Scheduled them monthly/ Weekly/ Daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Reports Performance.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

SKILLS: MS SQL Server 2008R2 Analysis Services SSAS , SSRS, SSIS, T-SQL, Win 2003 Advanced Server, Erwin v7.3, SQL Profiler, Database Engine Tuning Advisor, .NET, VB.NET, SQL Server Agent.

Confidential

BI Developer/ DBA

Responsibilities:

• Worked with applications developers and productions teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server 2005 on the production server.
• Automated the migration of data from Oracle DB to MS SQL Server 2005 DB, using Microsoft SQL Server Migration Assistant SSMA .
• Converted the Oracle DB Objects to MS SQL Server 2005 DB Objects like tables, views, and stored procedures.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Created SSIS packages to load data from the OLTP system to a Data Mart for analyzing data.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Perspectives and browsing translations since most transactions were online.
• Documented the development work and production release for future reference.
• Generated automatically grouping attribute members and implemented the calculations to aggregate physical measures.

SKILLS: Microsoft SQL Server 2005, SSAS, SSIS, Visual Studio 2005, T-SQL, MS Access, Windows XP, Erwin v4.0., SSMA.