SUMMARY

• 10+ year’s expertise of SQL Server Developer and managing 10TB+ database.
• Designing and developing a Big Data and Enterprise Data Warehouse wif ETL processes.
• Tune database performance, SQL Server Profiler, Transact - SQL
• PowerShell scripting to automate job tasks
• Experience wif entire software development lifecycle (SDLC) model.
• Expertise on SSAS,SSIS, SharePoint, SSRS, Modeling, Dimensions, Fact Tables, Stored Procs
• Strong knowledge of Asset management (Fix Income, Equities)
• Manage multiple workflow and tutor junior team member

TECHNICAL SKILLS

Languages: R, Matlab,Python,MSSQL Server 2008/2012/2014, SSIS, SSAS, Excel DAX/MDM, OLAP

Report Server, Oracle.:

Database: SQL Server, Oracle, MongoDB, DB2. NOSQL MongoDB, T-SQL, SSIS, SSRS

O/S: Window Server 2008/Unit/Linux

Software: VS2012, SQL Server 2012/2014, TOAD, Oracle SQL Developer. C#, Java, C++

Tools: SharePoint, Powerpivot, Sharepoint, Teradata, Hadoop, Informatica, Visio, XML parsing tool, Access SharePoint, DBCC, SQLSentry, SQL Server 2012 Diagnostic Information Queries, Cognos, Tableau.

PROFESSIONAL EXPERIENCE

Confidential, NYC

Sr. SQL Developer

Responsibilities:

• Strong experience and knowledge of SQL Server 2005/2008 administration and optimization. Expertise on SSIS / SSAS / SSRS, cube and data modeling, SharePoint. 10TB+ DB
• Experience integrating Excel wif Data transfer/ETL wif a deep knowledge of the SSIS (Integration Services).
• Responsible for the development of all Reporting, Analytics, Line of Business, Management and Financial Systems.
• MSBI suite and Teradata of products (SSIS/SSRS/SSAS/Power BI (Power View, Power Pivot, Power Query, Power Map)/ PerformancePoint (on SharePoint)/MDS/DQS/Data Mining).
• Design Data Warehouse/Big Data (NOSQL) ETL process model/architectures as Data Architect for enterprise team.
• Work wif developers, business analysts, other team members and clients to provide technical guidance during each phase of the development process.
• Work wif business owners and analysts in planning and estimating throughout the complete life cycle, review the business requirements and as well as identify and evaluate alternatives and present the most efficient and cost TEMPeffective solution.
• Excellent working wif large development teams and global team.
• Exposure to data modeling, predictive analytics, and forecasting techniques

Confidential, NYC

Sr. SQL Developer

Responsibilities:

• Design and implement ETL framework wif features like error handling, logging, data quality, data security
• Collect the business requirements and merge them into the design and implementation for all end-to-end BI/Data Warehousing solutions.
• Strong hands-on experience in SharePoint, R, Matlab, C++, .Net/C#, Python, Informatics. Preferably wif Teradata as source/target
• Design a Data warehouse / BI project in finance / banking environment, OLAP, Cube.
• Excellent understanding of the Data warehouse life cycle right from data source to ETL to transformations to multidimensional models like data marts, star schema and BI reporting through reporting tools like Business Objects
• Data quality and lifecycle management processes (SCD,DQM)
• Ability to TEMPeffectively be the single point of contact for the team to the external world
• Exposure to data modeling, predictive analytics, and forecasting techniques
• Strong analytical and troubleshooting skills, SSIS/SSAS/SSRS, Powerpivot - DAX/MDM/Tabular models, Sharepoint, .Net/C#, Teradata, Informatica.

Confidential, NYC

Sr. SQL Developer

Responsibilities:

• MSBI suite and SharePoint of products (SSIS/SSRS/SSAS/Power BI (Power View, Power Pivot, Power Query, Power Map)/ PerformancePoint (on SharePoint)/MDS/DQS/Data Mining).
• Specialized knowledge of using R,Matlab,Python, Java, PowerShell, VB scripting and Batch scripting for IIS, ACL and other administrative activities wif Server Operations team to automate server configuration and admin activities
• Generate enterprise analytical hierarchy revenue report. Significantly reduces millions dollars spent.
• Create prediction modeling to halp corporation pricing/scheduling strategy.
• Ability to navigate UNIX/Linux environments, working knowledge of shell scripting.
• Work wif Autosys, job scheduling, and scripting to implement data migration and integration.
• Conducted several POC's on CLOUD technologies in Windows Azure.

Confidential

Sr. SQL Developer

Responsibilities:

• Plan and implement disaster recovery procedures, 2TB+ DB
• Ensure data integrity, security and Failover Clustering
• Develop Transact-SQL objects and write DML for production support
• Design schemas as required
• Monitor production environments
• Provide data architecture guidance
• Facilitate the efficient flow of data
• Perform database upgrades, patches and migrations
• Work wif developers in their interactions wif the databases.
• Participate in an on call rotation.
• Governance frameworks and design patterns, factory pattern, builder pattern, state pattern, strategy pattern, visitor pattern, adapter pattern, fly weight pattern, Interpreter pattern, iterator pattern, mediator pattern, memento pattern, UML and observer pattern.
• Build wealth management core business application including research analytical report for portfolio manager, performance and risk calculation for funds products for management and administration using 70/30 views methodology.
• Expertise in developing Data Warehouse, ETL, Data Mart, data modeling, PowerShell scripting.Net/C# etc.
• Participation in an on-call rotation to provide 24/7 database support
• Monitor incident ticket queue and troubleshoot and resolve database incidents wifin SLAs
• Monitor backup results and resolve/troubleshoot failed database backups
• Monitor storage capacity and consumption, trend long term usage, and proactively work wif Architecture group to plan SAN procurement
• Monitor database and server performance and identify current and future potential bottle-necks
• Review, maintain, and periodically test database recovery procedures
• Monitor violations discovered by security compliance tool and remediate issues as needed
• Apply database security patches
• Apply database maintenance patches and upgrade databases to supported release levels
• Perform new builds as required by discretionary projects
• Support application upgrades of third party software, where a database
• Experience wif managing enterprise DaaS/SaaS solutions

Confidential, South Plainfield, NJ

Sr. SQL Developer/SQL DBA

Responsibilities:

• SharePoint, Replication, able to replicate and restore DB, and data integrity
• Database Mirroring/Transactional Log Shipping technology
• Windows PowerShell scripting
• TSQL performance tuning
• Handle multiple tasks and adapt to a constantly changing environment using .Net/C#,Visio.
• Good organizational and communications skills to be able to TEMPeffectively work across teams and interact wif business partners wif six sigma.
• Be responsible for commission report, reconciliation and tracing account transaction.