SUMMARY

• Over 8 years of Database Analyst of experience on source to target mapping, gathering business requirements from business/user, creating source to target mapping document, creating process flows, and DFD.
• Worked on various Domains like Banking, Financial and Telecommunications.
• Excellent understanding of Data Warehousing Concepts - Star and Snowflake schema, SCD Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.
• Extensive experience in SQL Query Optimization, Debugging, Performance Tuning and Troubleshooting and Data Investigating. Also, Worked with heterogeneous relational databases such as Teradata Oracle, MS Access and SQL Server.
• Experience in working third party tools like WinSQL, TOAD and SQL Developer.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1 and Visio 10.0.
• Experience in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC), Agile Methodologies and Scrum Master.
• Well versed with Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS, PL\ SQL Scripts
• Extensive experience in SQL Query Optimization, Debugging, Performance Tuning and Troubleshooting and Data Investigating.
• Skilled in programming complex tasks - Stored Procedures.
• Expertise in Performance tuning, Data integrity, Optimization and Statistics by using SQL Profiler
• Have novice hands-on experience on Python, Machine learning, UNIX shell Scripting and AWS Architecture design and S3.
• Experience in gathering Business Requirements and translating them into technical specification and creating reports with respect to business requirement.
• Excellent communication, interpersonal and analytical skills and adaptable to new technologies.
• Strong in problem solving, logical thinking and data analysing.
• UAT Analysis and Support, test case generation and Execution and Production release script preparation. Production and UAT support during release and UAT testing respectively.
• Unit testing and Test case Preparation and execution.
• Results-oriented fast learner with strong leadership skills focused on teamwork.
• Vendor Management. BCP Management.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2008 R2/2012/2014, DB2, MS-Access, Oracle. AWS (RDS/Redshift/Dynamo DB)

Tools: & Utilities: SharePoint, Visual Studio 2008/2012/2014 , TOAD 9.0, MS Office, Visio, Index Tuning Wizard, SQL Query Analyser, Toad, Sql Developer, Eclipse, Anaconda/Spyder, Microsoft Word, Excel, PowerPoint, Outlook.

Programming: SQL, T-SQL, R, UNIX, Python, Shell Scripting and Java.

Version Control: VSS, SVN, GIT.

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL BI Developer

Responsibilities:

• Created databases objects using T-SQL, scripts, stored procedures, Views.
• Created complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views,Indexes and otherSQLjoins and statements for applications.
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2005.
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Used Query Analyzer, Index Wizard, DB Engine Tuning andSQLProfiler for performance tuning.
• Created ComplexSQLQueries using Views, Indexes, Triggers, Roles, Stored procedures and User.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• Defined Functions. Created Complex Stored Procedures and automated them usingSQLServer Agent.
• Experience in implemented Stored Procedures and Triggers for automating tasks.
• Planed and implemented user log in and security.
• Wrote T-SQLprocedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Worked with Enterprise Manager for job scheduling and batch queries.
• Compressed data files by removing empty database pages and updating index statistics.
• Managed and monitored the system utilization.

Environment: MS-SQLServer 2008R2 Enterprise Manager, MS-SQLServer 2008, OracleSQL Developer, TOAD, MS Business intelligence (BIDS) SSIS, SSRS, SSAS, SharePoint Server 2010, XML, MS Excel, MS Visio 2010, Windows Server 2008, SQLCMD Utility JIRA.

Confidential

SQL BI DEVELOPER

Responsibilities:

• Worked on Stored Procedures, functions, Triggers and Cursors and Collections.
• Lead the End to End delivery of each of the requirement.
• Designed and developed various complex reports with sub-reports, parameters, charts, formula and grouping.
• Created few jobs in the SQL Server to automate the existing stored procedures.
• Created External tables in Oracle database to read data from the flat files on the Unix server and generate reports using the same.
• Code Debug and read the files using the Pro*C and generate reports from the Oracle forms and Oracle Reports.
• Production support for the application and Production incidents resolution and preparation of the Root cause analysis.
• Inspect the database for Performance related issues and load balancing on the Unix server by using TOP commands.
• Generation of log files for file reading/loading and sending e-mails through stored procedures using SMTP
• UAT Support and release script Preparation and execution of the same scripts in Production environment.
• Provided BI solutions as “monthly reports” to the business team.
• Developed various weekly and monthly reports, and maintained their schedules and subscriptions.
• Involved in code cleanup and redesign of existing procedures to improve performance.
• Code review and code enhancement for better performance.
• Working with core product development team to create high performance data migration applications using Pro*C, Java and SQL.
• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Generating the Reports and test cases.
• UAT Support and release script Preparation and execution of the same scripts in Production environment.
• Participated in developing presentations and training manuals as per project specifications and timelines.
• Worked as a team member to create project tracking system tool which helps maintaining details of incidents.

Environment: MS Excel, MS Access, VSS, Oracle 10G, Oracle Forms and reports, Java, Pro*C Hp-Unix. Visio, SVN, VSS. Whizible, T-SQL, Windows, TOAD, SQL Developer, Eclipse

Confidential

SQL Server Developer/DBA

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQLin Development and Production environment forSQLServer.
• Maintained security by creating users and giving appropriate permissions to users.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Wrote T-SQLprocedures to generate DML scripts that modified database objects dynamically based on user inputs.
• DevelopedSQLQueries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and maintaining logs.
• Involved in performance tuning and monitoring of both T-SQLand PL/SQLblocks.
• UsedSQLProfiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQLprocedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQLfor various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Worked on MSSQLServer tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Created DTS Packages and T-SQLStored Procedures for the ETL Process.
• Involved in End to End Testing of tools i.e. Data validation check for the tools.
• Analyzed reports and fixed bugs in stored procedures.
• Involved in document reviews, test plan, integration of the system.
• OLTP transaction handled through stored procedures called through oracle jobs and Cron Jobs.

Environment: MS Excel 2003/2007, MS Access 2003, VSS, Oracle 10G, Developer 2000, D2k, Oracle Forms and reports, Visual Basic, Hp-Unix. Visio, SVN, VSS. Whizible, TOAD, SQL Developer, Eclipse.

Confidential

SQL Developer

Responsibilities:

• Involved in the study of existing system.
• Designed and developed the database from scratch, created clustered indexes, created and optimized the stored procedures and triggers and constraints.
• Maintained the production, test and development databases, tuned the database by improving relations, integrity constraints and written t-SQLprocedures for transactions, created indexes for performance tuning.
• Responsible for understanding the customer requirements and database administration.
• Participated in meetings with the client and team members.
• Developed triggers and stored procedures to in corporate the business logic and process.
• Using the data transformation tasks like BCP, bulk inserts to import/export data from clients.
• Created users, roles and giving appropriate permissions to the members as part of the security implementation. Scheduled the jobs to run on monthly basis.
• Used validation techniques and java script for user input validation.
• Supported front-end development team to resolveSQLrelated issues in active server pages design and develop user control for the application.
• Major role in documentation and maintenance.
• Worked as a trainer on various Applications Used as Internal to NSEIL.
• Worked on writing Scripts (Create, Drop, Insert, Update, Alter and Delete).
• Have training and hands-on experience on VB, UNIX Scripting, and Linux server.
• Developed several forms and reports using Forms Developer and D2K.
• Design and Develop shell scripting and Cron jobs for the Project modules to run the jobs.
• Testing for the Developed modules and automated script run.
• UAT testing along with the users to understand business model and support for the same.

Environment: SQLServer 2005/2000, MS Excel 2003/2007, MS Access 2003, VSS, Oracle8i, Oracle9i, Developer 2000, D2k, Oracle Forms and reports, Visual Basic, Hp-Unix TOAD, SQL Developer.